
SWC_QUIZ_4
Quiz
•
Computers
•
University
•
Practice Problem
•
Medium
Shabnam Choudhary
Used 2+ times
FREE Resource
Enhance your content in a minute
60 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which SQL statement is used to create an index on a column?
Answer explanation
CREATE INDEX is used to create an index on a table column.
2.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What is the main benefit of using indexes?
Answer explanation
Indexes improve query speed, especially for SELECT statements with WHERE.
3.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following can negatively impact performance when overused?
Answer explanation
Too many indexes can slow down INSERT, UPDATE, and DELETE operations.
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
How can you see whether a query uses an index in SQL Server?
Answer explanation
SQL Server's Query Plan Viewer shows if indexes are being used.
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What happens when you drop an index?
Answer explanation
Dropping an index can reduce read performance.
6.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
Which of the following is TRUE about CTEs in SQL?
Answer explanation
CTEs are temporary and exist only during query execution.
7.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
What is a key difference between Views and CTEs?
Answer explanation
Views are saved in the database; CTEs are not.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
62 questions
Trắc nghiệm nhập môn OOP
Quiz
•
University
62 questions
Building and Securing a Small Network
Quiz
•
University
60 questions
Doors
Quiz
•
1st Grade - Professio...
60 questions
Keamanan Jaringan
Quiz
•
University
62 questions
ÔN TẬP Giữa Kỳ Môn Tin Học 8
Quiz
•
7th Grade - University
60 questions
Tin học Chương 1
Quiz
•
University
60 questions
FakeNews
Quiz
•
9th Grade - University
60 questions
HARDWARE MAINTENANCE TROUBLESHOOTING QUIZ
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
