MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 5 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The high performance mode is only available in the __________ edition of SQL Server. |
| A. | Enterprise |
| B. | Express |
| C. | Compact |
| D. | None of the mentioned |
| Answer» B. Express | |
| 2. |
Which of the following modes writes the data on the principal and mirror databases synchronously ? |
| A. | High safety with automatic cluster |
| B. | High safety |
| C. | High safety with automatic failover |
| D. | High performance |
| Answer» B. High safety | |
| 3. |
Database mirroring operates in how many modes ? |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» C. 4 | |
| 4. |
Which of the following benefit is provided by database mirroring ? |
| A. | Increases data protection |
| B. | Improves the availability of the production database |
| C. | Increases availability of a database |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
___________ feature will be removed in a future version of Microsoft SQL Server. |
| A. | Log shipping |
| B. | Database snapshots |
| C. | Database mirroring |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |