What is a Cartesian product?
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 |
how do you resolve -805?
What is concurrency in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
can any one give the list of some important sql abend codes which r frequently asked in interviews?
cursor with hold explain ?
What is dclgen (declaration generator)?
What are the two types of logging in the db2 database? Explain them.
When would you prefer to use VARCHAR?
What does db2 mean?
What is the use of value function?
What DB2 Catalog column tell you when an index needs table reorganized ?
Are views updatable ?