SQL MCQ - English

Set 9 MCQ Questions and Answers

Home | SQL | Set 9

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: 1/7

1) Benefits that SQL Server failover cluster instances provide:

    Protection at the instance level through redundancy
    Disaster recovery solution using a multi-subnet FCI
    Zero reconfiguration of applications and clients during failovers
    All of the mentioned

Answer : D Discuss

2) The resources owned by WSFC node include:

    Destination address
    SQL Server Browser
    One file share resource, if the FILESTREAM feature is installed
    None of the mentioned

Answer : C Discuss

3) None of the mentioned

    WSFC Resource Group
    SQL Server Binaries
    Network Name
    Storage

Answer : B Discuss

4) Which of the the following operation requires to run SQL Server Setup on the node?

    Add
    Remove
    Update
    All of the mentioned

Answer : D Discuss

5) A Windows Failover Cluster can support up to _______ nodes.

    12
    14
    16
    18

Answer : C Discuss

6) Which of the following is a Windows Failover Cluster quorum mode?

    Node Majority
    No Majority: Read Only
    File Read Majority
    None of the mentioned

Answer : A Discuss

7) An exciting new feature in SQL Server 2014 is the support for the deployment of a Failover Cluster Instance (FCI) with :

    Cluster Shared Volumes (CSV)
    In memory database
    Column oriented database
    All of the mentioned

Answer : A Discuss

8) Which of the following feature prefers SQL Server authentication mode over windows authentication?

    Backward compatibility
    Forward compatibility
    Security
    All of the mentioned

Answer : A Discuss

9) Windows Authentication Mode is not available when an instance of SQL Server is running on :

    Windows 98
    Windows 7
    Windows 95
    All of the mentioned

Answer : A Discuss

10) Which of the following authentication modes is more secure ?

    SQL Server Authentication
    Windows Authentication
    Mixed Mode
    All of the mentioned

Answer : B Discuss

Jump to Pages:

1 2 3 4 5 6 7

MCQ Category