SQL Plus Interview Question:

Explain What is a Cartesian product?

Submitted by: Administrator

A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join.
Submitted by: Administrator