What is a Cartesian product?

COBOL SQL Interview Questions

(Continued from previous question...)

What is a Cartesian product?

A Cartesian product results from a faulty query. It is a row in the results for every combination in the join tables.

(Continued on next question...)

Other Interview Questions

• What is a correlation name?
• What is a foreign key?
• What is a tuple?
• What is an object?
• What is the use of VALUE function?
• What is the basic differnce between a join and a union?
• What is referential integrity?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What RDMS objects are required before you can create a table ?
• What is a view? Why use it ?
• More...