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

R

Ram Sharma • 193.86K Points
Coach 

Q. Which of the following joins are SQL server default?

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

Q. Exception handling is possible in SQL Server using _____________

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

Q. DML triggers in SQL Server is applicable to _____________

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

R

Ram Sharma • 193.86K 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

Loding content...

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.