Answer Posted / 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 |
Post New Answer View All Answers
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What are the various data types available in db2?
How to restart a DB2 program?
What is a storage group (stogroup)?
what is the role of the cursor in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Why do we bind in db2?
Is schema the same as database?
what is the responsibility of the construction superintendent
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
List down the types of triggers in the db2 database?
What is access path in db2?
When do you specify the isolation level?
How do I copy a table in db2?
Define sqlca.