This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Database Mirroring”.
1. ___________ 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
View Answer
Explanation: Use AlwaysOn Availability Groups instead of database mirroring.
2. Point out the correct statement.
a) Database mirroring is a solution for lowering the availability of a SQL Server database
b) Log shipping is a solution for increasing the availability of a SQL Server database
c) Mirroring is implemented on a per-database basis
d) All of the mentioned
View Answer
Explanation: Mirroring works only with databases that use the full recovery model.
3. 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
View Answer
Explanation: To minimize downtime for a mirrored database, you can sequentially upgrade the instances of SQL Server that are hosting the failover partners.
4. Database mirroring operates in how many modes?
a) 2
b) 3
c) 4
d) 5
View Answer
Explanation: Database mirroring operates in three different modes: high-availability mode, high-protection mode, and high-performance mode.
5. Point out the wrong statement.
a) Mirror database is the copy of the database that is typically fully synchronized with the principal database
b) Redo queue is received transaction log records that are waiting on the disk of a mirror server
c) Database mirroring provides less redundancy of the data
d) All of the mentioned
View Answer
Explanation: Database mirroring provides complete or almost complete redundancy of the data depending on whether the operating mode is high-safety or high-performance.
6. 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
View Answer
Explanation: In high safety with automatic cluster, Data is written and must be committed synchronously both on the principal and mirror databases.
7. The high performance mode is only available in the __________ edition of SQL Server.
a) Enterprise
b) Express
c) Compact
d) None of the mentioned
View Answer
Explanation: In high performance mode, the asynchronous communication, data is written and committed on the principal server, and later sent and committed to the mirror server.
8. Which of the following script will backup the database requires for database mirroring?
a)
USE master GO Backup DATABASE DB1 TO disk ='C:\Backups\DB1.Bak' WITH initialize GO Backup log DB1 TO disk ='C:\Backups\DB1.trn' WITH initialize GO
b)
USE master GO Backup DATABASE DB1 TO disk ='C:\Backups\DB1.Bak' WITH init GO Backup log DB1 TO disk ='C:\Backups\DB1.trn' WITH init GO
c)
USE master GO Back DATABASE DB1 TO disk ='C:\Backups\DB1.Bak' WITH init GO Back log DB1 TO disk ='C:\Backups\DB1.trn' WITH init GO
d) All of the mentioned
View Answer
Explanation: You have to backup the database and transaction on the principal server for database mirroring.
9. Which of the following is an upgrade step to database mirroring?
a) Switch to high performance (sync)
b) Perform a rolling upgrade
c) Switch back to high performance (sync)
d) None of the mentioned
View Answer
Explanation: Upgrade mirror, manual failover to mirror, upgrade original principal, manual failover to original principal.
10. Which of the following pair of technology is supported in SQL Server?
a) Mirroring and Replication
b) Mirroring and Clustering
c) Mirroring and Log Shipping
d) All of the mentioned
View Answer
Explanation: Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.
Sanfoundry Global Education & Learning Series – SQL Server.
To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.
- Practice Programming MCQs
- Apply for Programming Internship
- Check SQL Server Books
- Check Information Technology Books