Multiple Choice
Which type of index in SQL Server is faster for data retrieval?
A) Clustered
B) Nonclustered
C) Unique
D) Baseline
E) There is no advantage to any particular index for data retrieval,only for data updating.
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q6: The column(s)that is/are the primary key in
Q8: Which of the following is not a
Q10: In SQL Server,the full recovery model creates
Q12: Which type(s)of index in SQL Server has/have
Q13: SQL Server security provides three modes of
Q16: Which of the following is the default
Q29: SQL Server supports three types of indexes:
Q51: When viewing a table in the GUI
Q75: With SQL Server,the clustered index is faster
Q80: In the Microsoft SQL Server Management Studio,the