This set of solved MCQ on SQL server includes MCQ questions about the fundamental of SQL server and the basic commands used on SQL server.
1. …………………… is the full form of SQL.
A) Standard Query Language
B) Sequential Query Language
C) Structured Query Language
D) Server Side Query Language
2. SQL Server 2005 NOT includes the following system database ………….
A) tempdb Database
B) Master Database
C) Model Database
D) sqldb Database
3. SQL Server stores index information in the ………………… system table.
A) sysindexes
B) systemindexes
C) sysind
D) sysindexes
4. ………………… is a read-only database that contains system objects that are included with SQL Server 2005.
A) Resource Database
B) Master Database
C) Model Database
D) msdb Database
5. The SQL Server services include…………………
A) SQL server agent
B) Microsoft distribution transaction coordinator
C) Both a & b
D) None of the above
6. …………………. is a utility to capture a continuous record of server activity and provide auditing capability.
A) SQL server profile
B) SQL server service manager
C) SQL server setup
D) SQL server wizard
7. The query used to remove all references for the pubs and newspubs databases from the system tables is ……………………..
A) DROP DATABASE pubs, newpubs;
B) DELETE DATABASE pubs, newpubs;
C) REMOVE DATABASE pubs, newpubs;
D) DROP DATABASE pubs and newpubs;
8. …………………. clause specifies the groups into which output rows are to be placed and, if aggregate functions are included in the SELECT clause.
A) ORDER BY
B) GROUP
C) GROUP BY
D) GROUP IN
9. ……………… are predefined and maintained SQL Server where users cannot assign or directly change the values.
A) Local Variables
B) Global Variables
C) Assigned Variables
D) Direct Variables
10. Microsoft SQL Server NOT uses which of the following operator category?
A) Bitwise Operator
B) Unary Operator
C) Logical Operator
D) Real Operator
Answers:
1. C) Structured Query Language
2. D) sqldb Database
3. D) sysindexes
4. A) Resource Database
5. C) Both a & b
6. B) SQL server service manager
7. A) DROP DATABASE pubs, newpubs;
8. C) GROUP BY
9. B) Global Variables
10.D) Real Operator
Read Next: Solved MCQ of SQL Server Set-2
Read More: Collections of DBMS MCQ questions
Download: Free PDF E-book of DBMS MCQ questions
Comments are closed.