Explore topic-wise MCQs in Structured Query Language (SQL).

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
Discussion
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
Discussion
3.

Database mirroring operates in how many modes ?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
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.
Discussion
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
Discussion