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 9: Indexes & Performance Quiz
Answer all questions to test your understanding
1
What is the purpose of an index?
To speed up data retrieval
To slow down queries
To delete data
To store data
2
What is the downside of having too many indexes?
They slow down INSERT, UPDATE, and DELETE
They speed up everything
They have no downside
They use no storage
3
Which columns should you index?
Columns you frequently filter or sort by
All columns
Only primary keys
Only foreign keys
4
What is a composite index?
An index on multiple columns
An index on one column
An index that is always unique
An index on a view
5
Does a PRIMARY KEY have an index automatically?
Yes, SQL Server creates one automatically
No, you must create one manually
Only for VARCHAR columns
Only for INT columns
Submit Quiz