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
Ans : C
Explanation: MS SQL Server is a relational database management system (RDBMS).
2. 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.
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
Ans : D
Explanation: All of the statement are true about MS SQL.
4. 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
5. Which programming language is used to developed MS SQL?
A. C
B. C++
C. Both A and B
D. Java
View Answer
Ans : C
Explanation: Programming languages: C, C++
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
Ans : D
Explanation: All of the above is an Advantages of Instances (SQL Server).
7. SQL Server works in client-server architecture, supports how many types of components?
A. 2
B. 3
C. 4
D. 5
View Answer
Ans : A
Explanation: SQL Server works in client-server architecture, hence it supports two types of components : (a) Workstation and (b) Server.
8. 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
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
Ans : B
Explanation: SQL OS : This lies between the host machine (Windows OS) and SQL Server. All the activities performed on database engine are taken care of by SQL OS.
10. 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.
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
Ans : C
Explanation: Manual : This one runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion. Manual checkpoint runs for your current database only.
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
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.
13. How much maximum file can be there in one database?
A. 65536
B. 16384
C. 32764
D. 32767
View Answer
Ans : D
Explanation: There can be up to 32,767 files in one database.
14. 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.
15. The size of the page is?
A. 2 kb
B. 4 kb
C. 8 kb
D. 16 kb
View Answer
Ans : C
Explanation: It is the fundamental unit of data storage in MS SQL Server. The size of the page is 8KB.
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
Ans : A
Explanation: Each log record is identified by Log Sequence Number (LSN).
17. Rollback operations are also logged
A. TRUE
B. FALSE
C. Can be true or false
D. Can not say
View Answer
Ans : A
Explanation: Rollback operations are also logged. Each transaction reserves space on the transaction log to make sure that enough log space exists to support a rollback that is caused by either an explicit rollback statement or if an error is encountered.
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
Ans : D
Explanation: Query Optimizer : It will prepare the execution plan as output by taking query, statistics and Algebrizer tree as input.
19. How many types of file groups in SQL Server?
A. 1
B. 3
C. 4
D. 2
View Answer
Ans : D
Explanation: There are two types of file groups in SQL Server, Primary and User-defined. Primary file group contains the primary data file and any other files not specifically assigned to another file group. All pages for the system tables are allocated in the primary file group. User-defined file groups are any file groups specified using the file group keyword in create database or alter database statement.
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