MS SQL Server - 20 - Removing Database Objects MCQ

20 – Removing Database Objects MCQ

Best of luck!

1 / 19

1. What is the purpose of the DROP DATABASE statement in SQL Server?

To create a new database

To delete an existing database

To perform database backups

To modify an existing database

2 / 19

2. In SQL Server, which statement is used to delete a specific table from a database?

ERASE TABLE

DROP TABLE

DELETE TABLE

REMOVE TABLE

3 / 19

3. What is the role of the DROP INDEX statement in SQL Server?

To delete an existing index from a table

To create a new table

To add a new index to a table

To modify the properties of an index

4 / 19

4. In SQL Server, which statement is used to delete a view from the database?

ERASE VIEW

REMOVE VIEW

DROP VIEW

DELETE VIEW

5 / 19

5. What is the primary purpose of the DROP PROCEDURE statement in SQL Server?

To delete an existing stored procedure from the database

To add a new stored procedure to the database

To create a new function

To modify the code of a stored procedure

6 / 19

6. In SQL Server, which statement is used to delete a function from the database?

DROP FUNCTION

ERASE FUNCTION

DELETE FUNCTION

REMOVE FUNCTION

7 / 19

7. What is the role of the DROP TRIGGER statement in SQL Server?

To modify the properties of a trigger

To create a new table

To delete an existing trigger from a table

To add a new trigger to a table

8 / 19

8. In SQL Server, which statement is used to delete a user-defined type (UDT) from the database?

DELETE UDT

REMOVE UDT

DROP UDT

ERASE UDT

9 / 19

9. What is the primary purpose of the DROP SCHEMA statement in SQL Server?

To add a new schema to the database

To delete an existing schema from the database

To create a new table

To modify the structure of a schema

10 / 19

10. In SQL Server, which statement is used to delete a database role?

DROP ROLE

DELETE ROLE

REMOVE ROLE

ERASE ROLE

11 / 19

11. What is the purpose of the DROP ASSEMBLY statement in SQL Server?

To create a new table

To modify the code of an assembly

To delete an existing assembly from the database

To add a new assembly to the database

12 / 19

12. In SQL Server, which statement is used to delete a sequence object from the database?

REMOVE SEQUENCE

DELETE SEQUENCE

ERASE SEQUENCE

DROP SEQUENCE

13 / 19

13. What is the role of the DROP LOGIN statement in SQL Server?

To add a new login to the database

To create a new user-defined type

To delete an existing login from the database

To modify the properties of a login

14 / 19

14. In SQL Server, which statement is used to delete a credential from the database?

ERASE CREDENTIAL

DROP CREDENTIAL

REMOVE CREDENTIAL

DELETE CREDENTIAL

15 / 19

15. What is the primary purpose of the DROP SYNONYM statement in SQL Server?

To create a new view

To add a new synonym to the database

To modify the structure of a synonym

To delete an existing synonym from the database

16 / 19

16. In SQL Server, which statement is used to delete a schema-bound view from the database?

ERASE VIEW

DELETE VIEW

DROP VIEW

REMOVE VIEW

17 / 19

17. What is the role of the DROP AGGREGATE statement in SQL Server?

To modify the code of an aggregate function

To delete existing aggregate function from the database

To create a new table

To add a new aggregate function to the database

18 / 19

18. In SQL Server, which statement is used to delete a user-defined data type (UDDT) from the database?

REMOVE UDDT

DELETE UDDT

DROP UDDT

ERASE UDDT

19 / 19

19. What is the primary purpose of the DROP USER statement in SQL Server?

To disable a user

To delete a user

To modify a user

To enable a user

Your score is

MS SQL Server – 20 – Removing Database Objects MCQ