MS SQL Server Questions & Answers
11. MS SQL Server developed by?
A. Microsoft
B. IBM
C. Oracle
D. Google
View Answer
Ans : A
Explanation: MS SQL Server is a relational database management system (RDBMS) developed by Microsoft.
12. Microsoft SQL Server Initial release on?
A. 1988
B. 1989
C. 1990
D. 1991
View Answer
Ans : B
Explanation: Initial release: April 24, 1989; 31 years ago, as SQL Server 1.0
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
Ans : D
Explanation: All of the above is an Advantages of Instances (SQL Server).
14. How many protocol SQL Server has?
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : C
Explanation: In SQL Server we have 4 protocols : Shared memory, Named pipes, TCP/IP, VIA-Virtual Interface Adapter
15. In SQL Server 2012 how many types of checkpoints there?
A. 3
B. 4
C. 5
D. 6
View Answer
Ans : B
Explanation: In SQL Server 2012 there are four types of checkpoints : Automatic, Indirect, Manual and Internal.
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
Ans : A
Explanation: Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is .mdf.
17. Which extents are made up of only single object?
A. mixed
B. uniform
C. double
D. single
View Answer
Ans : B
Explanation: SQL Server has two types of extents - Uniform and Mixed. Uniform extents are made up of only single object. Mixed extents are shared by up to eight objects.
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
Ans : A
Explanation: Each log record is identified by Log Sequence Number (LSN).
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
Ans : D
Explanation: Query Optimizer : It will prepare the execution plan as output by taking query, statistics and Algebrizer tree as input.
20. The recommended extension for log file is ?
A. .idf
B. .ldf
C. .udf
D. .rdf
View Answer
Ans : B
Explanation: Log files hold all of the log information used to recover the database. Database must have at least one log file. We can have multiple log files for one database. The recommended extension for log file is .ldf.
Discussion