JOIN Operations
6 practice questionsDatabase SystemsStep-by-step solutions
Try a few
1
A LEFT JOIN returns all rows from:
A.The right table
B.The left table (plus matches)
C.Neither table
D.Only matches
2
What is the purpose of a SQL JOIN?
A.Combine rows from related tables
B.Delete every table
C.Encrypt a password
D.Start a web server
3
Which JOIN returns only the rows that have matching values in both tables?
A.LEFT JOIN
B.INNER JOIN
C.FULL OUTER JOIN
D.CROSS JOIN
Master join operations โ not just preview it
All 6 questions with worked solutions, an AI tutor that explains every step, and games that make the drilling stick. Free to start.
Practice this topic freeNo card needed ยท 10 free AI questions daily