MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 2 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server 2000 knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following is not a factor in determining the concurrency control behavior of SQL Server? |
| A. | Lock level |
| B. | Transaction isolation level |
| C. | Cursor concurrency setting |
| D. | Locking hints |
| Answer» B. Transaction isolation level | |
| 2. |
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data |
| A. | Nonclustered |
| B. | Clustered |
| C. | Primary |
| D. | Secondary |
| Answer» B. Clustered | |