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:

2) The resources owned by WSFC node include:

3) None of the mentioned

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

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

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

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

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

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

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