Home / Programming Questions / SQL Server MCQs / Page 2

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 • 188.81K Points
Coach

Q. SQL Server has mainly how many types of views?

(A) four
(B) three
(C) one
(D) two

R

Ram Sharma • 188.81K Points
Coach

Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

(A) sys.dm_exec_connections
(B) INFORMATION_SCHEMA.KEY_COLUMN_USAGE
(C) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
(D) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE

R

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

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.