SQL Plus Question:

Explain What is a Cartesian product?

Tweet Share WhatsApp

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 PDF Read All 20 SQL Plus Questions
Previous QuestionNext Question
Explain some PL/SQL Exceptions?Explain What is an Integrity Constraint?