MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index. |
| A. | Clustered |
| B. | Column store |
| C. | Non clustered |
| D. | Row store |
| Answer» C. Non clustered | |
| 2. |
If an index is _________________ the metadata and statistics continue to exists |
| A. | Disabling |
| B. | Dropping |
| C. | Altering |
| D. | Both Disabling and Dropping |
| Answer» B. Dropping | |