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
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?
What is meant by union and union all?
How to find schema of a table in db2?
Why db2 is called db2?
Mention the downsides of page level lock.
What is a db2 table?
define clustering index.
What is a bind in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How do I create a view in db2?
How to get the ddl of a table in db2?
What is a page in db2?
What is copy pending and check pending in db2?
What is an instance in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?