Multiple Choice
Which of the following is true of clustered indexes?
A) They are normally slower than nonclustered indexes for retrieving data.
B) Only one is allowed per table.
C) They are normally slower than nonclustered indexes for updating data.
D) They do not have data in the bottom level.
E) A and C
Correct Answer:
Verified
Correct Answer:
Verified
Q1: To use an SQL Server reserved word
Q3: Explain two ways of creating tables in
Q6: Describe the database files that are automatically
Q16: Which of the following is the default
Q22: The default cursor concurrency setting for a
Q39: Briefly explain the different SQL Server recovery
Q50: SQL Server supports AFTER and INSTEAD OF
Q52: SQL Server automatically creates an index on
Q80: In the Microsoft SQL Server Management Studio,the
Q98: The default cursor concurrency for a dynamic