Explore topic-wise MCQs in SQL Server.

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.

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

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

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

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

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

Which of the following database cannot be dropped?

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

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

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