1. Which is the minimal permission that a user must have to drop the database ?
Correct Answer is : CONTROL
2. Which of the following statement removes sales and suppliers database ?
Correct Answer is : DROP DATABASE Sales, suppliers
3. Which of the following statement is used to create database snapshot ?
Correct Answer is : CREATE DATABASE
4. Syntax for dropping a database snapshot named “Sushant” would be :
Correct Answer is : DROP DATABASE Sushant
5. View used used for displaying current status of database is :
Correct Answer is : sys.databases
6. Point out the wrong statement :
Correct Answer is : A database cannot be dropped regardless of its state
7. Which of the following database should be backed up regularly ?
Correct Answer is : Master
8. The DROP DATABASE statement must run in ________ mode?
Correct Answer is : Autocommit
9. Features provided by ALTER DATABASE statement do not include :
Correct Answer is : Deletes database
10. Point out the correct statement:
Correct Answer is : Database snapshots cannot be modified
11. Command used to shrink the size of database is:
Correct Answer is : DBCC SHRINKDATABASE
12. Maximum number of filegroups specified for each database is :
Correct Answer is : 32, 767
13. When does most ALTER DATABASE statements fail ?
Correct Answer is : Database is in the RESTORING state
14. Which of the following statement modifies view index ?
Correct Answer is : ALTER INDEX
15. Which of the following index options are added by CREATE INDEX statement ?
Correct Answer is : ONLINE
16. Point out the wrong statement with respect to ALTER INDEX statement :
Correct Answer is : None of the mentioned
17. Which of the following adds MOVE TO clause ?
Correct Answer is : DROP INDEX
18. Which is a new DDL statement ?
Correct Answer is : CREATE APPLICATION ROLE
19. Which of the following creates a new Microsoft Windows or SQL Server login account ?
Correct Answer is : CREATE LOGIN
20. Statement used to remove a user from the current database is :
Correct Answer is : DROP USER