SQL Server Interview Questions - 9 | Snaprecruit.com

SQL Server Interview Questions - 9 | Snaprecruit.com

SQL Server interview questions part 9

SQL Server interview questions part 9

Take as many assements as you can to improve your validate your skill rating

Total Questions: 20

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

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon