SQL Server MCQs with answers Page - 3

Here, you will find a collection of MCQ questions on SQL Server. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 802.91K Points
Coach

Q. Which of the stored procedure is used to test the SQL injection attack?

  • (A) xp_reg
  • (B) xp_write
  • (C) xp_regwrite
  • (D) all of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which is the default field terminator for bulk insert in SQL Server?

  • (A) Brackets
  • (B) Parenthesis
  • (C) Full stop
  • (D) Comma

A

Admin • 802.91K Points
Coach

Q. Which of the following is the main feature of dotConnect for SQL Server?

  • (A) Supports the latest versions of SQL Server
  • (B) Extra data binding capabilities
  • (C) Ability of monitoring query execution
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following is used to overcome the Replication in SQL Server?

  • (A) Availability problems
  • (B) Maintenance problems
  • (C) Performance problems
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data

  • (A) unlink
  • (B) import
  • (C) link
  • (D) all of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following SQL Server tools is used to enhance data management and governance?

  • (A) SSDT
  • (B) OBEII
  • (C) SSIT
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. Backing up your SQL Server database is essential for _______ your data.

  • (A) replication
  • (B) protecting
  • (C) preventing
  • (D) none of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following is the instance of SQL Server that is your production server in log shipping?

  • (A) secondary server
  • (B) primary server
  • (C) secondary database
  • (D) primary database

A

Admin • 802.91K Points
Coach

Q. Which of the following pair of technology is supported in SQL Server?

  • (A) Mirroring and Clustering
  • (B) Mirroring and Log Shipping
  • (C) Mirroring and Replication
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following is the biggest disadvantage of SQL Server Authentication mode?

  • (A) Allows SQL Server to support Web-based applications where users create their own identities
  • (B) Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication
  • (C) SQL Server Authentication cannot use Kerberos security protocol
  • (D) None of the mentioned

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.