SQL Plus Question:

Download Job Interview Questions and Answers PDF

Explain What is a Cartesian product?

SQL Plus Interview Question
SQL Plus Interview Question

Answer:

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.

Download SQL Plus Interview Questions And Answers PDF

Previous QuestionNext Question
Explain some PL/SQL Exceptions?Explain What is an Integrity Constraint?