Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

Maximum number of filegroups specified for each database is ___________

A. 32, 667
B. 32, 777
C. 32, 766
D. 32, 767
Answer» E.
Discussion
2.

When does most ALTER DATABASE statements fail?

A. Database is in the RESTORING state
B. Database is in the STORING state
C. Database is in the RESTORE state
D. None of the mentioned
Answer» B. Database is in the STORING state
Discussion
3.

DDL statements not used for Synonym is __________

A. CREATE SYNONYM
B. DROP SYNONYM
C. ALTER SYNONYM
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
4.

Which of the following statement drops the synonym?

A. DELETE SYNONYM
B. DROP SYNONYM
C. REMOVE SYNONYM
D. None of the mentioned
Answer» E.
Discussion
5.

Command used to modify the schema is __________

A. ALTER SCHEMA
B. ALTER STRUCTURE
C. ALTER VIEW
D. DBCC SHRINKDB
Answer» B. ALTER STRUCTURE
Discussion
6.

Creation of new database role in the current database is made by __________

A. CREATE APPLICATION ROLE
B. CREATE ROLE
C. CREATE USER
D. CREATE LOGIN
Answer» C. CREATE USER
Discussion
7.

Command used to shrink the size of the database is _____________

A. DBCC SHRINK
B. SHRINKDATABASE
C. DBCC SHRINKDATABASE
D. DBCC SHRINKDB
Answer» D. DBCC SHRINKDB
Discussion
8.

Which of the following adds MOVE TO clause?

A. DROP INDEX
B. ALTER INDEX
C. UPDATE INDEX
D. CREATE INDEX
Answer» B. ALTER INDEX
Discussion
9.

Which of the following statement modifies view index?

A. ALTER INDEX
B. ALTER VIEW INDEX
C. ALTER INDEX_VIEW
D. None of the mentioned
Answer» B. ALTER VIEW INDEX
Discussion
10.

Statement used to remove a user from the current database is ____________

A. DROP ROLE
B. DROP USER
C. DROP LOGIN
D. None of the mentioned
Answer» C. DROP LOGIN
Discussion
11.

Which of the following creates a new Microsoft Windows or SQL Server login account?

A. CREATE LOGIN
B. DROP LOGIN
C. UPDATE LOGIN
D. REMOVE LOGIN
Answer» B. DROP LOGIN
Discussion
12.

Which is a new DDL statement?

A. DROP ROLES
B. CREATE APPLICATION ROLE
C. CREATE USERS
D. None of the mentioned
Answer» C. CREATE USERS
Discussion
13.

Purpose of ALTER CERTIFICATE is __________

A. Adds a private key to a certificate
B. Changes the public key of a certificate
C. Removes the certificate from the database
D. None of the mentioned
Answer» B. Changes the public key of a certificate
Discussion
14.

Point out the wrong statement with respect to ALTER INDEX statement.

A. Adds new format for specifying index and table names
B. Adds the index option:MAXDOP
C. Adds the index option:ONLINE
D. None of the mentioned
Answer» E.
Discussion
15.

Which of the following index options are added by the CREATE INDEX statement?

A. XML INDEX
B. INCLUDED (column)
C. PARTITION SCHEME
D. ONLINE
Answer» E.
Discussion
16.

Features provided by ALTER DATABASE statement do not include ____________

A. Deletes database
B. Modifies file
C. Changes the attributes of a database
D. Changes the database collation
Answer» B. Modifies file
Discussion
17.

The DROP DATABASE statement must run in ________ mode.

A. Autocommit
B. Commit
C. Readcommit
D. None of the mentioned
Answer» B. Commit
Discussion
18.

Which of the following database should be backed up regularly?

A. Adventure Works
B. Pub
C. TEMPDB
D. Master
Answer» E.
Discussion
19.

What options did ALTER DATABASE statement add?

A. DATABASE SNAPSHOT syntax
B. ATTACH_REBUILD_LOG clause
C. DB_CHAINING option
D. READ_COMMITTED_SNAPSHOT
Answer» E.
Discussion
20.

Syntax for dropping a database snapshot named “Sushant” would be ____________

A. DROP DATABASE Sushant
B. DROP DATABASE SNAP Sushant
C. DROP SNAPSHOT Sushant
D. None of the mentioned
Answer» B. DROP DATABASE SNAP Sushant
Discussion
21.

View used for displaying current status of database is ___________

A. system.databases
B. current.databases
C. sys.databases
D. status.databases
Answer» D. status.databases
Discussion
22.

VIEW_USED_USED_FOR_DISPLAYING_CURRENT_STATUS_OF_DATABASE_IS_:?$

A. system.databases
B. current.databases
C. sys.databases
D. status.databases
Answer» D. status.databases
Discussion
23.

Syntax for dropping a database snapshot named “Sushant” would be ?#

A. DROP DATABASE Sushant
B. DROP DATABASE SNAP Sushant
C. DROP SNAPSHOT Sushant
D. None of the mentioned
Answer» B. DROP DATABASE SNAP Sushant
Discussion
24.

Which of the following statement is used to create database snapshot ?

A. CREATE DATABASE
B. CREATE SNAPSHOT
C. CREATE SNAPDB
D. None of the mentioned
Answer» B. CREATE SNAPSHOT
Discussion
25.

Which of the following statement removes sales and suppliers database ?

A. DROP DATABASE Sales, NewSales
B. DROP DATABASE Sales, suppliers
C. DROP DATABASE Sales and suppliers
D. DROP DATABASE Sales-suppliers
Answer» C. DROP DATABASE Sales and suppliers
Discussion
26.

Which is the minimal permission that a user must have to drop the database ?

A. READ
B. WRITE
C. VIEW
D. CONTROL
Answer» E.
Discussion
27.

Which of the following database cannot be dropped ?

A. TEMPDB
B. Master
C. MSDB
D. All of the mentioned
Answer» E.
Discussion
28.

Which of the following statement removes database including its related components ?

A. DROP DATABASE
B. DELETE DATABASE
C. REMOVE DATABASE
D. None of the mentioned
Answer» B. DELETE DATABASE
Discussion
29.

Which of the following item is provided by CREATE DATABASE statement ?

A. Service Broker options
B. ALLOW_SNAPSHOT_ISOLATION
C. DB_CHAINING
D. Database mirroring
Answer» B. ALLOW_SNAPSHOT_ISOLATION
Discussion
30.

What options did ALTER DATABASE statement add ?

A. DATABASE SNAPSHOT syntax
B. ATTACH_REBUILD_LOG clause
C. DB_CHAINING option
D. READ_COMMITTED_SNAPSHOT
Answer» E.
Discussion