Explanation:Clustered indexes sort and store the data rows in the table based on their key values. 9. Which of the the following option is immediately applied to the index by using the SET clause in the ALTER INDEX statement ?
A. ALLOW_PAGE_LOCKS
B. ALLOW_COLUMN_LOCKS
C. STATISTICS_RECOMPUTE
D. None of the mentioned
Answer:A
Explanation:Clustered indexes sort and store the data rows in the table based on their key values. 9. Which of the the following option is immediately applied to the index by using the SET clause in the ALTER INDEX statement ?
A. ALLOW_PAGE_LOCKS B. ALLOW_COLUMN_LOCKS C. STATISTICS_RECOMPUTE D. None of the mentioned
Explanation:ALTER INDEX statement requires ALTER permission on the table or view. 10. Which of the following code snippet demonstrates ALTER statement with STATISTICS_NORECOMPUTE in ONLINE state ?