SQL CROSS JOIN MCQ Cartesian Product Practice Questions

Direction: Choose the correct option

What is a CROSS JOIN?

A. Outer join

B. Inner join

C. Cartesian product of two tables

D. Union of tables

Direction: Choose the correct option

SELECT * FROM colors CROSS JOIN sizes;

How many rows result if colors has 5 rows and sizes has 4?

A. 5 rows

B. 1 row

C. 20 rows

D. 9 rows

Direction: Choose the correct option

When would you use CROSS JOIN?

A. Update data

B. Filter data

C. Find matches

D. Generate all combinations

Direction: Choose the correct option

SELECT * FROM employees e, departments d WHERE e.dept_id = d.dept_id;

What does this old syntax represent?

A. RIGHT JOIN

B. INNER JOIN

C. CROSS JOIN with condition

D. LEFT JOIN

Direction: Choose the correct option

SELECT * FROM dates CROSS JOIN time_slots;

What might this be used for?

A. Time calculation

B. Booking system time slots

C. Date arithmetic

D. Finding matching dates

Quipoin Menu