SQL Server MCQs with answers Page - 3

Dear candidates you will find MCQ questions of SQL Server here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

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
💬 Discuss
✅ Correct Answer: (C) xp_regwrite

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:11 pm in SQL Server

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

  • (A) Brackets
  • (B) Parenthesis
  • (C) Full stop
  • (D) Comma
💬 Discuss
✅ Correct Answer: (D) Comma

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:11 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:12 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:14 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (A) unlink

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:14 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (A) SSDT

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:15 pm in SQL Server

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

  • (A) replication
  • (B) protecting
  • (C) preventing
  • (D) none of the mentioned
💬 Discuss
✅ Correct Answer: (B) protecting

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:15 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (B) primary server

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:16 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (D) All of the mentioned

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:17 pm in SQL Server

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
💬 Discuss
✅ Correct Answer: (C) SQL Server Authentication cannot use Kerberos security protocol

Published by Ram Sharma ⭐ 193.88K Points at 09-Jun-2022 01:18 pm in SQL Server

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play