SQL Server MCQs with answers Page - 26

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. Why type of user is the default in sql server?

  • (A) SINGLE_USER
  • (B) MULTI_USER
  • (C) RESTRICTED_USER
  • (D) ROOT_USER

A

Admin • 802.91K Points
Coach

Q. When SQL server is installed, which of the following databases are created by default?

  • (A) Master
  • (B) Model
  • (C) Both a and b
  • (D) Root

A

Admin • 802.91K Points
Coach

Q. Stored procedures are safe from SQL injection attacks

  • (A) True
  • (B) False
  • (C) NA
  • (D) NA

A

Admin • 802.91K Points
Coach

Q. Which of the following below are valid database states?

  • (A) OFFLINE
  • (B) SUSPECT
  • (C) EMERGENCY
  • (D) All of the above

A

Admin • 802.91K Points
Coach

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

A

Admin • 802.91K Points
Coach

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

A

Admin • 802.91K Points
Coach

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

  • (A) True
  • (B) False
  • (C) NA
  • (D) NA

A

Admin • 802.91K Points
Coach

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

  • (A) UNIQUE
  • (B) IDENTITY
  • (C) INCREMENT
  • (D) ADD

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.