SQL Server MCQs with answers Page - 27

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. What is a MULTI_USER in sql server?

  • (A) users that have the appropriate permissions to connect to the database are allowed
  • (B) One user at a time is allowed to connect to the database
  • (C) Only some members are allowed to access the database
  • (D) Only the system admin and some members are allowed to access the database
💬 Discuss
✅ Correct Answer: (A) users that have the appropriate permissions to connect to the database are allowed

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:18 pm in SQL Server

Q. What is the difference between adhoc queries from stored procedures?

  • (A) Adhoc queries are placed embedded in the business logic code
  • (B) Stored procedures are placed embedded in the business logic code
  • (C) There is no difference as both are fired on the databases
  • (D) None of the above
💬 Discuss
✅ Correct Answer: (A) Adhoc queries are placed embedded in the business logic code

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:19 pm in SQL Server

Q. A candidate key cannot be regarded as a possible primary key

  • (A) True
  • (B) False
  • (C) NA
  • (D) NA
💬 Discuss
✅ Correct Answer: (B) False

Published by Rajeev Malhotra ⭐ 3.97K Points at 23-Jul-2022 03:19 pm in SQL Server

Q. Which keyword is used in SQL Server to implement the auto increment?

  • (A) UNIQUE
  • (B) IDENTITY
  • (C) INCREMENT
  • (D) ADD
💬 Discuss
✅ Correct Answer: (B) IDENTITY
Explanation: IDENTITY keyword is used in SQL Server to implement the auto-increment.

Published by Shivam ⭐ 8.86K Points at 08-May-2023 05:07 am 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