Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Cartesian product?
- 2 Answers
- 10265 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m4io
a cartesian product is a join between two tables where
the join-condition + where-conditions do not deliver a
unique key on either table.
it is a n*m relationship.
Not necessarily faulty (Star joins use cartesian products)
| Is This Answer Correct ? | 4 Yes | 1 No |
What is a cursor and what is its function?
What are delete-connected tables?
How do you eliminate duplicate values in db2?
Explain the EXPLAIN statement?
How can you quickly find out the # of rows updated after an update statement?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is scrollable cursor in db2?
What are PACKAGES ?
What is Declaration Generator(DCLGEN)?
What does reorg do in db2?
How to handle null values in db2
COBOL 
