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. MS SQL Server developed by?

A. Microsoft
B. IBM
C. Oracle
D. Google

View Answer


3. 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


4. Microsoft SQL Server Initial release on?

A. 1988
B. 1989
C. 1990
D. 1991

View Answer


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

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

View Answer


6. Which of the following is an Advantages of Instances (SQL Server)?

A. To reduce cost
B. To reduce temporary database problems
C. To separate security privileges
D. All of the above

View Answer


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

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

View Answer


8. How many protocol SQL Server has?

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

View Answer


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

A. Storage Engine
B. SQL OS
C. Query Executor
D. Query Optimizer

View Answer


10. In SQL Server 2012 how many types of checkpoints there?

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

View Answer


11. 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


12. Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?

A. .mdf
B. .ndf
C. .ldf
D. .pdf

View Answer


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

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

View Answer


14. Which extents are made up of only single object?

A. mixed
B. uniform
C. double
D. single

View Answer


15. The size of the page is?

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

View Answer


16. Each log record is identified by Log Sequence Number (LSN).

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


17. Rollback operations are also logged

A. TRUE
B. FALSE
C. Can be true or false
D. Can not say

View Answer


18. Which of the following prepare the execution plan as output by taking query, statistics and Algebrizer tree as input?

A. Query Parser
B. Execution Plan
C. Query Executor
D. Query Optimizer

View Answer


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

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

View Answer


20. The recommended extension for log file is ?

A. .idf
B. .ldf
C. .udf
D. .rdf

View Answer





Discussion


* You must be logged in to add comment.