SQL Server MCQs with answers Page - 2

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

  • (A) Inner
  • (B) Equi
  • (C) Outer
  • (D) None of the Mentioned
💬 Discuss
✅ Correct Answer: (A) Inner

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

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

  • (A) UNIQUE
  • (B) NOT NULL
  • (C) CHECK
  • (D) NULL
💬 Discuss
✅ Correct Answer: (D) NULL

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

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

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

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
💬 Discuss
✅ Correct Answer: (C) Combination of relational and XML data type columns

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

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

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

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
💬 Discuss
✅ Correct Answer: (A) Control-of-flow language

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

Q. Exception handling is possible in SQL Server using _____________

  • (A) FINAL
  • (B) FINALLY
  • (C) THROW
  • (D) All of the mentioned
💬 Discuss
✅ Correct Answer: (C) THROW

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

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

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

Q. DML triggers in SQL Server is applicable to _____________

  • (A) Update
  • (B) Delete
  • (C) Insert
  • (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:10 pm in SQL Server

Q. User defined function in SQL Server can return ____________

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