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 4: SELECT, WHERE, ORDER BY Quiz
Answer all questions to test your understanding
1
What does SELECT * FROM Students do?
Returns all columns from the Students table
Returns only the first column
Deletes the Students table
Creates a new table
2
What is the purpose of WHERE in SQL?
Filters rows based on a condition
Sorts the results
Groups the results
Adds new rows
3
What does ORDER BY do?
Sorts the results
Filters the results
Groups the results
Adds new rows
4
What does ORDER BY LastName DESC do?
Sorts by LastName in descending order
Sorts by LastName in ascending order
Filters by LastName
Deletes rows with LastName
5
Which clause filters rows based on a condition?
WHERE
ORDER BY
SELECT
GROUP BY
Submit Quiz