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. 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.
3. 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++
4. 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.
5. 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.
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
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.
7. 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.
8. 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.
9. 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.
10. 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.
Discussion