What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table? MCQ with Answer and Explanation
What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table?
A. Left Join
B. Natural Join
C. Cross Join
D. Inner Join
Answer: Option C
Solution (By JKSSB Mock Tests)
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.
Explanation:
Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.
No comments yet. Be the first to start the discussion!