SQL Server MCQs with answers Page - 2

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 following joins are SQL server default?

  • (A) Inner
  • (B) Equi
  • (C) Outer
  • (D) None of the Mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following is not a class of constraint in SQL Server?

  • (A) UNIQUE
  • (B) NOT NULL
  • (C) CHECK
  • (D) NULL

A

Admin • 802.91K Points
Coach

Q. Which of the reasons will force you to use the XML data model in SQL Server?

  • (A) Order is inherent in your data
  • (B) Your data is sparse or you do not know the structure of the data
  • (C) Your data represents containment hierarchy
  • (D) All of the Mentioned

A

Admin • 802.91K Points
Coach

Q. What is the hybrid model in SQL Server?

  • (A) Using XML with views
  • (B) Using XML with triggers
  • (C) Combination of relational and XML data type columns
  • (D) Combination of relational and non relational data type columns

A

Admin • 802.91K Points
Coach

Q. Which of the following feature of SQL Server was used before XML technology for semi structured data?

  • (A) In memory database
  • (B) Stored Procedure
  • (C) Dynamic management views
  • (D) None of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following language is used for procedural flow in SQL Server?

  • (A) Control-of-flow language
  • (B) Flow language
  • (C) Control language
  • (D) None of the mentioned

A

Admin • 802.91K Points
Coach

Q. Exception handling is possible in SQL Server using _____________

  • (A) FINAL
  • (B) FINALLY
  • (C) THROW
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. Which of the following stored procedure is already defined in SQL Server?

  • (A) System defined Procedure
  • (B) CLR Stored Procedure
  • (C) Extended Procedure
  • (D) User Defined Stored Procedure

A

Admin • 802.91K Points
Coach

Q. DML triggers in SQL Server is applicable to _____________

  • (A) Update
  • (B) Delete
  • (C) Insert
  • (D) All of the mentioned

A

Admin • 802.91K Points
Coach

Q. User defined function in SQL Server can return ____________

  • (A) Result set
  • (B) Scalar value
  • (C) Set of values
  • (D) All 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.