Multiple Choice Questions - Drop Indexes
1. The DROP INDEX statement ....... to indexes created while defining PRIMARY KEY or any of the UNIQUE constraints.
A) applies
B) does not apply
C) applies with few conditions
D) none of above
2. We can drop only one index at a time from a table.
A) True
B) False
3. Below is the statement to drop multiple indexes at once. Is the statement correct?
B) False
4. To execute DROP INDEX, a minimum of, ……. permission on the table / view is needed.
A) Delete
B) Disable
C) Drop
D) Alter
5. When you drop a primary XML index, all associated secondary XML indexes are automatically dropped.
A) True
B) False
6. Which of the following index options can be set while dropping a clustered index:
A) MAXDROP
B) ONLINE
C) MOVE TO
D) MAXDOP
E) OFFLINE
7. An index cannot be dropped if the filegroup in which it is located is .... or .......
A) hidden
B) constrained
C) offline
D) set to read-only
8. Which of the following statement is correct?
A) When the clustered index of an indexed view is dropped then only the non-clustered indexes on the same view are automatically dropped.
B) When the clustered index of an indexed view is dropped then only the auto-created statistics on the same view are automatically dropped.
C) When the clustered index of an indexed view is dropped, all non-clustered indexes and auto-created statistics on the same view are automatically dropped.
D) When the clustered index of an indexed view is dropped, all non-clustered indexes and manually statistics on the same view are automatically dropped.
9. As soon as an index is dropped, the resulting heap appears in the sys.indexes catalog view with ...... in the name column.
A) NULL
B) Index_Number
C) Primary Key
D) Random Number
10. An index which is used by a primary key or unique constraint cannot be dropped directly. You must use the ………. command.
A) alter constraint
B) drop constraint
C) delete constraint
D) eventdata constraint
Answers
1. The DROP INDEX statement ....... to indexes created while defining PRIMARY KEY or any of the UNIQUE constraints.
A) applies
B) does not apply
C) applies with few conditions
D) none of above
2. We can drop only one index at a time from a table.
A) True
B) False
3. Below is the statement to drop multiple indexes at once. Is the statement correct?
DROP INDEX
Index_1 FROM Table_1,
Index_2 FROM Table_2;
GO
A) TrueB) False
4. To execute DROP INDEX, a minimum of, ……. permission on the table / view is needed.
A) Delete
B) Disable
C) Drop
D) Alter
5. When you drop a primary XML index, all associated secondary XML indexes are automatically dropped.
A) True
B) False
6. Which of the following index options can be set while dropping a clustered index:
A) MAXDROP
B) ONLINE
C) MOVE TO
D) MAXDOP
E) OFFLINE
7. An index cannot be dropped if the filegroup in which it is located is .... or .......
A) hidden
B) constrained
C) offline
D) set to read-only
8. Which of the following statement is correct?
A) When the clustered index of an indexed view is dropped then only the non-clustered indexes on the same view are automatically dropped.
B) When the clustered index of an indexed view is dropped then only the auto-created statistics on the same view are automatically dropped.
C) When the clustered index of an indexed view is dropped, all non-clustered indexes and auto-created statistics on the same view are automatically dropped.
D) When the clustered index of an indexed view is dropped, all non-clustered indexes and manually statistics on the same view are automatically dropped.
9. As soon as an index is dropped, the resulting heap appears in the sys.indexes catalog view with ...... in the name column.
A) NULL
B) Index_Number
C) Primary Key
D) Random Number
10. An index which is used by a primary key or unique constraint cannot be dropped directly. You must use the ………. command.
A) alter constraint
B) drop constraint
C) delete constraint
D) eventdata constraint
Answers