C# Mastery Hub
Home
Challenges
Discussion
Lessons
Core Topics
C# Fundamentals
Console Applications
Classes & OOP
Windows Forms
ASP.NET Core
SQL Server
VS & SQL Connection
RDLC Reports
.NET MAUI
Getting Started
Getting Started
Website Development
SEO Guide
Security
Project Workflow
Extra Topics
Cloud & Deployment
AWS Cloud
Deployment
About
Contact
Test Your Knowledge
SQL Server - Lesson 5: Joins Quiz
Answer all questions to test your understanding
1
What does INNER JOIN do?
Returns only matching rows from both tables
Returns all rows from the left table
Returns all rows from both tables
Deletes matching rows
2
What does LEFT JOIN do?
Returns all rows from the left table, matched or not
Returns only matching rows
Returns all rows from both tables
Returns only rows from the right table
3
When should you use LEFT JOIN?
When you want all rows from the main table even if there's no match
When you only want matching rows
When you want to delete data
When you want to insert data
4
What is the difference between INNER JOIN and LEFT JOIN?
INNER JOIN returns only matches, LEFT JOIN returns all rows from the left table
They are the same
INNER JOIN is faster
LEFT JOIN is faster
5
Which join returns all rows from both tables, matched where possible?
FULL JOIN
INNER JOIN
LEFT JOIN
RIGHT JOIN
Submit Quiz