MS SQL Server Questions & Answers

11. MS SQL Server developed by?

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

View Answer


12. Microsoft SQL Server Initial release on?

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

View Answer


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


14. How many protocol SQL Server has?

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

View Answer


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

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

View Answer


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


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

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

View Answer


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


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


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.