Database Mirroring MCQ

Test your knowledge with important Database Mirroring MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Database Mirroring MCQs at Bissoy

• The high performance mode is only available in the __________ edition of SQL Server.
  ক

  Enterprise

  খ

  Express

  গ

  Compact

  ঘ

  None of the mentioned
• Which of the following modes writes the data on the principal and mirror databases synchronously?
  ক

  High safety with automatic cluster

  খ

  High safety

  গ

  High safety with automatic failover

  ঘ

  High performance
• Database mirroring operates in how many modes?
  ক

  2

  খ

  3

  গ

  4

  ঘ

  5
• Which of the following benefit is provided by database mirroring?
  ক

  Increases data protection

  খ

  Improves the availability of the production database

  গ

  Increases availability of a database

  ঘ

  All of the mentioned
• ___________ feature will be removed in a future version of Microsoft SQL Server.
  ক

  Log shipping

  খ

  Database snapshots

  গ

  Database mirroring

  ঘ

  None of the mentioned