MS SQL Server MCQ Questions And Answers

MS SQL Server MCQ : This section focuses on "Basics" of MS SQL Server. These Multiple Choice Questions (MCQ) should be practiced to improve the MS SQL Server skills required for various interviews (campus interviews, walk-in interviews, company interviews), placements, entrance exams and other competitive examinations.

1. MS SQL Server is a ?

A. Centralised database
B. Distributed database
C. Relational database
D. Personal database

View Answer

2. Which of the following statement are true about SQL Server?

A. It is also an ORDBMS
B. It is platform dependent
C. It is both GUI and command based software
D. All of the above

View Answer

3. Which programming language is used to developed MS SQL?

A. C
B. C++
C. Both A and B
D. Java

View Answer

4. SQL Server works in client-server architecture, supports how many types of components?

A. 2
B. 3
C. 4
D. 5

View Answer

5. Which of the following lies between the host machine (Windows OS) and SQL Server?

A. Storage Engine
C. Query Executor
D. Query Optimizer

View Answer

6. Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?

A. Automatic
B. Indirect
C. Manual
D. Internal

View Answer

7. How much maximum file can be there in one database?

A. 65536
B. 16384
C. 32764
D. 32767

View Answer

8. The size of the page is?

A. 2 kb
B. 4 kb
C. 8 kb
D. 16 kb

View Answer

9. Rollback operations are also logged

C. Can be true or false
D. Can not say

View Answer

10. How many types of file groups in SQL Server?

A. 1
B. 3
C. 4
D. 2

View Answer


* You must be logged in to add comment.