SQL MCQ - English

Set 8 MCQ Questions and Answers

Home | SQL | Set 8

SQL MCQ Questions and Answers : We provide sql quiz questions and answers, here learn mcq questions related to Structured Query Language and test online of objective questions and free download pdf.

Page: 7/7

61) Which of the following table stores history detail for log shipping jobs ?

    log_shipping_monitor_alert
    log_shipping_monitor_primary
    log_shipping_monitor_history_detail
    None of the mentioned

Answer : C Discuss

62) _________ maps primary databases to secondary databases in log shipping.

    sp_change_log_shipping_primary_database
    log_shipping_primary_databases
    log_shipping_primary_secondaries
    sp_help_log_shipping_primary_database

Answer : C Discuss

63) _____ feature will be removed in a future version of Microsoft SQL Server.

    Log shipping
    Database snapshots
    Database mirroring
    None of the mentioned

Answer : C Discuss

64) 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

Answer : D Discuss

65) Database mirroring operates in how many modes ?

    2
    3
    4
    5

Answer : B Discuss

66) 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

Answer : A Discuss

67) The high performance mode is only available in the __________ edition of SQL Server.

    Enterprise
    Express
    Compact
    None of the mentioned

Answer : A Discuss

68) Which of the following is upgrade step to database mirroring ?

    Switch to high performance (sync)
    Perform a rolling upgrade
    Switch back to high performance (sync)
    None of the mentioned

Answer : B Discuss

69) Which of the following pair of technology is supported in SQL Server ?

    Mirroring and Replication
    Mirroring and Clustering
    Mirroring and Log Shipping
    All of the mentioned

Answer : D Discuss

70) Which of the following scenario prefers failover cluster instance over stand alone instance in SQL Server?

    High Confidentiality
    High Availability
    High Integrity
    None of the mentioned

Answer : B Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category