MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |
| 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 | |
| 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 | |
| 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 | |
| 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. | |
| 6. |
Which of the following database cannot be dropped? |
| A. | TEMPDB |
| B. | Master |
| C. | MSDB |
| D. | All of the mentioned |
| Answer» E. | |
| 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 | |
| 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 | |