 
			 
			MCQOPTIONS
 Saved Bookmarks
				| 1. | 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» B. ALLOW_COLUMN_LOCKS | |