MS SQL Server - 19 - Alter Database & Table MCQ

19 – Alter Database & Table MCQ

Best of luck!

1 / 25

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

To create a new database

To modify an existing database

To perform database backups

To delete a database

2 / 25

2. In SQL Server, which statement is used to change the name of a database?

ALTER DATABASE RENAME TO

ALTER DATABASE MODIFY NAME TO

ALTER DATABASE MODIFY FILE

ALTER DATABASE SET NAME

3 / 25

3. What is the purpose of the MODIFY FILE option in the ALTER DATABASE statement?

To change the name of a database

To modify the properties of a database file

To delete a database file

To add a new database file

4 / 25

4. In SQL Server, which statement is used to add a new filegroup to a database?

ALTER DATABASE ADD FILEGROUP

ALTER DATABASE CREATE FILEGROUP

ALTER DATABASE SET FILEGROUP

ALTER DATABASE MODIFY FILEGROUP

5 / 25

5. What is the role of the ALTER TABLE statement in SQL Server?

To insert data into a table

To delete an existing table

To modify the structure of an existing table

To create a new table

6 / 25

6. In SQL Server, which statement is used to add a new column to an existing table?

ALTER TABLE MODIFY COLUMN

ALTER TABLE CREATE COLUMN

ALTER TABLE SET COLUMN

ALTER TABLE ADD COLUMN

7 / 25

7. What is the purpose of the MODIFY COLUMN option in the ALTER TABLE statement?

To change the name of a column

To insert data into a column

To delete a column from a table

To modify the data type or properties of an existing column

8 / 25

8. In SQL Server, which statement is used to delete a column from an existing table?

ALTER TABLE ERASE COLUMN

ALTER TABLE DELETE COLUMN

ALTER TABLE REMOVE COLUMN

ALTER TABLE DROP COLUMN

9 / 25

9. What is the primary role of the ALTER TABLE DROP CONSTRAINT statement in SQL Server?

To modify an existing constraint

To remove an existing constraint from a table

To delete a table

To add a new constraint to a table

10 / 25

10. In SQL Server, which statement is used to modify an existing constraint on a table?

ALTER TABLE MODIFY COLUMN CONSTRAINT

ALTER TABLE MODIFY CONSTRAINT

ALTER TABLE CHANGE CONSTRAINT

ALTER TABLE ALTER CONSTRAINT

11 / 25

11. What is the purpose of the ENABLE TRIGGER option in the ALTER TABLE statement?

To delete a trigger from a table

To modify the structure of a trigger

To disable all triggers on a table

To enable a specific trigger on a table

12 / 25

12. In SQL Server, which statement is used to rename a table?

ALTER TABLE RENAME TO

ALTER TABLE SET NAME

ALTER TABLE MODIFY NAME TO

ALTER TABLE CHANGE NAME TO

13 / 25

13. What is the role of the ALTER TABLE statement when it includes the SET SCHEMA option?

To delete a schema from the database

To insert data into a table

To change the schema of an existing table

To modify the data type of a column

14 / 25

14. In SQL Server, which statement is used to change the collation of a column in an existing table?

ALTER TABLE SET COLLATION

ALTER TABLE CHANGE COLLATION

ALTER TABLE ALTER COLLATION

ALTER TABLE MODIFY COLLATION

15 / 25

15. What is the primary purpose of the DISABLE TRIGGER option in the ALTER TABLE statement?

To disable a specific trigger on a table

To delete a trigger from a table

To modify the structure of a trigger

To enable all triggers on a table

16 / 25

16. In SQL Server, which statement is used to change the data type of a column in an existing table?

ALTER TABLE SET DATA TYPE

ALTER TABLE CHANGE DATA TYPE

ALTER TABLE ALTER COLUMN

ALTER TABLE MODIFY COLUMN

17 / 25

17. What is the role of the ALTER TABLE statement when it includes the ADD CONSTRAINT option?

To modify an existing constraint

To add a new constraint to an existing table

To delete a table from the database

To add a new table to the database

18 / 25

18. In SQL Server, which statement is used to modify the properties of an existing index on a table?

ALTER TABLE CHANGE INDEX

ALTER TABLE SET INDEX

ALTER TABLE ALTER INDEX

ALTER TABLE MODIFY INDEX

19 / 25

19. What is the primary purpose of the ALTER TABLE statement when it includes the RENAME COLUMN option?

To rename an existing column in a table

To change the data type of a column

To delete a column from a table

To add a new column to a table

20 / 25

20. In SQL Server, which statement is used to delete all records from an existing table?

ALTER TABLE REMOVE RECORDS

ALTER TABLE DELETE TABLE

ALTER TABLE TRUNCATE TABLE

ALTER TABLE DELETE ALL RECORDS

21 / 25

21. What is the role of the ALTER TABLE statement when it includes the DISABLE option for a constraint?

To enable the constraint

To disable the constraint

To delete the constraint

To modify the constraint

22 / 25

22. In SQL Server, which statement is used to enable a previously disabled trigger on a table?

ALTER TABLE ENABLE TRIGGER

ALTER TABLE CHANGE TRIGGER STATUS

ALTER TABLE ACTIVATE TRIGGER

ALTER TABLE MODIFY TRIGGER

23 / 25

23. What is the purpose of the SET IDENTITY_INSERT option in the ALTER TABLE statement?

To change the identity seed of a column

To insert explicit values into an identity column

To reset the identity column to its initial value

To delete the identity column from a table

24 / 25

24. In SQL Server, which statement is used to change the identity seed value of an identity column in an existing table?

ALTER TABLE SET IDENTITY SEED

ALTER TABLE MODIFY IDENTITY SEED

ALTER TABLE CHANGE IDENTITY SEED

ALTER TABLE ALTER IDENTITY SEED

25 / 25

25. What is the primary role of the ALTER TABLE statement when it includes the ADD COLUMN option?

To change the data type of a column

To rename an existing column in a table

To add a new column to an existing table

To delete a column from a table

Your score is

MS SQL Server – 19 – Alter Database & Table MCQ