Solved MCQ of SQL Server set-1

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

Get 1000's of DBMS MCQs as pdf E-Book on Free Download Now