Test Your SQL Skills with ALTER TABLE Quizzes

Progress

True / False

In SQL Server, the ALTER TABLE statement can be used to add a new column to an existing table.

True False

The ALTER TABLE statement allows you to add a new column to an existing table.

True / False

You can use the ALTER TABLE statement to change the data type of an existing column in SQL Server.

True False

The ALTER TABLE statement allows you to change the data type of an existing column.

True / False

In SQL Server, you can use the ALTER TABLE statement to drop a column from a table.

True False

The ALTER TABLE statement allows you to drop an existing column from a table.

True / False

The ALTER TABLE statement in SQL Server can be used to rename a table.

True False

In SQL Server, the ALTER TABLE statement cannot rename a table; the sp_rename system stored procedure is used instead.

True / False

You can use the ALTER TABLE statement to add a primary key constraint to an existing table in SQL Server.

True False

The ALTER TABLE statement allows you to add a primary key constraint to an existing table.

True / False

In SQL Server, the ALTER TABLE statement cannot be used to modify a column's default value.

True False

The ALTER TABLE statement can be used to change the default value of a column.

True / False

You can use the ALTER TABLE statement to disable a foreign key constraint in SQL Server.

True False

The ALTER TABLE statement can be used to disable a foreign key constraint.

True / False

The ALTER TABLE statement in SQL Server can be used to move a table to a different schema.

True False

The ALTER TABLE statement can be used to move a table to a different schema using the SWITCH TO clause.

True / False

In SQL Server, the ALTER TABLE statement can be used to create an index on an existing table.

True False

Creating an index is done using the CREATE INDEX statement, not the ALTER TABLE statement.

Q10

True / False

You can use the ALTER TABLE statement to add a CHECK constraint to an existing table in SQL Server.

True False

The ALTER TABLE statement allows you to add a CHECK constraint to an existing table.

Q11

True / False

The ALTER TABLE statement in SQL Server can be used to change the collation of a column.

True False

You can use the ALTER TABLE statement to change the collation of a column.

Q12

True / False

In SQL Server, the ALTER TABLE statement cannot be used to modify a table's schema.

True False

The ALTER TABLE statement can be used to modify a table's schema, such as adding or dropping columns, constraints, and indexes.

Q13

True / False

You can use the ALTER TABLE statement to drop a primary key constraint from a table in SQL Server.

True False

The ALTER TABLE statement can be used to drop a primary key constraint from a table.

Q14

True / False

The ALTER TABLE statement in SQL Server can be used to rename a column.

True False

The ALTER TABLE statement in SQL Server can be used to rename a column using the sp_rename system stored procedure.

Q15

True / False

In SQL Server, the ALTER TABLE statement can be used to modify the identity property of an existing column.

True False

You cannot directly modify the identity property of an existing column using the ALTER TABLE statement.

Q16

Single Choice

Which SQL Server statement is used to add a new column to an existing table?

ADD COLUMN ALTER COLUMN ALTER TABLEMODIFY TABLE

The ALTER TABLE statement is used to add a new column to an existing table.

Q17

Single Choice

In SQL Server, which keyword is used to remove a column from an existing table?

DELETE COLUMN REMOVE COLUMN DROP COLUMNALTER COLUMN

The DROP COLUMN keyword is used with the ALTER TABLE statement to remove a column from an existing table.

Q18

Single Choice

Which clause is used to add a primary key constraint to an existing table in SQL Server?

ADD PRIMARY KEY ADD CONSTRAINT ALTER CONSTRAINTMODIFY CONSTRAINT

The ADD CONSTRAINT clause is used with the ALTER TABLE statement to add a primary key constraint.

Q19

Single Choice

In SQL Server, which keyword is used to change the data type of an existing column?

CHANGE COLUMN MODIFY COLUMN ALTER COLUMNUPDATE COLUMN

The ALTER COLUMN keyword is used with the ALTER TABLE statement to change the data type of an existing column.

Q20

Single Choice

Which statement is used to rename a column in SQL Server?

ALTER COLUMN MODIFY COLUMN RENAME COLUMNsp_rename

The sp_rename system stored procedure is used to rename a column in SQL Server.

Q21

Single Choice

In SQL Server, how can you add a NOT NULL constraint to an existing column?

ALTER COLUMN ADD CONSTRAINT MODIFY COLUMNUPDATE COLUMN

The ALTER TABLE statement can be used with the ALTER COLUMN keyword to add a NOT NULL constraint to an existing column.

Q22

Single Choice

Which keyword is used to disable a constraint in SQL Server?

DISABLE NOCHECK REMOVEDROP

The NOCHECK keyword is used with the ALTER TABLE statement to disable a constraint.

Q23

Single Choice

In SQL Server, which clause is used to change the default value of a column?

CHANGE DEFAULT MODIFY DEFAULT SET DEFAULTALTER COLUMN

The ALTER TABLE statement with the ALTER COLUMN keyword is used to change the default value of a column.

Q24

Single Choice

Which SQL Server statement is used to move a table to a different schema?

ALTER SCHEMA CHANGE SCHEMA MOVE SCHEMAMODIFY SCHEMA

The ALTER SCHEMA statement is used to move a table to a different schema.

Q25

Single Choice

In SQL Server, which statement is used to add a CHECK constraint to an existing table?

ALTER CONSTRAINT ADD CHECK ADD CONSTRAINTMODIFY CONSTRAINT

The ADD CONSTRAINT clause is used with the ALTER TABLE statement to add a CHECK constraint.

Q26

Single Choice

Which keyword is used to enable a previously disabled constraint in SQL Server?

ENABLE CHECK VALIDATEREENABLE

The CHECK keyword is used with the ALTER TABLE statement to enable a previously disabled constraint.

Q27

Single Choice

In SQL Server, how can you remove a NOT NULL constraint from an existing column?

REMOVE CONSTRAINT DROP CONSTRAINT MODIFY COLUMNALTER COLUMN

The ALTER TABLE statement with the ALTER COLUMN keyword is used to remove a NOT NULL constraint from an existing column.

Q28

Single Choice

Which SQL Server statement is used to change the collation of a column?

MODIFY COLLATION ALTER COLLATION CHANGE COLLATIONSET COLLATION

The ALTER TABLE statement with the ALTER COLUMN keyword is used to change the collation of a column.

Q29

Single Choice

In SQL Server, which statement is used to drop a default constraint from a column?

DELETE CONSTRAINT REMOVE CONSTRAINT DROP CONSTRAINTDISABLE CONSTRAINT

The ALTER TABLE statement with the DROP CONSTRAINT keyword is used to drop a default constraint from a column.

Q30

Single Choice

Which keyword is used to modify the schema of a table in SQL Server?

MODIFY SCHEMA ALTER SCHEMA CHANGE SCHEMAUPDATE SCHEMA

The ALTER SCHEMA keyword is used to modify the schema of a table.

Q31

Multiple Choice

Which of the following actions can be performed using the ALTER TABLE statement in SQL Server?

Add a new column Change the data type of a column Add a primary key constraintRename a table

The ALTER TABLE statement can be used for various actions such as adding columns, modifying columns, and adding constraints.

Q32

Multiple Choice

Which of the following constraints can be added to an existing table using the ALTER TABLE statement in SQL Server?

PRIMARY KEY FOREIGN KEY CHECKINDEX

The ALTER TABLE statement can add constraints such as PRIMARY KEY, FOREIGN KEY, and CHECK to an existing table.

Q33

Multiple Choice

Which of the following are valid keywords used with the ALTER TABLE statement in SQL Server?

ADD DROP ALTERREMOVE

Keywords such as ADD, DROP, and ALTER are valid with the ALTER TABLE statement.

Q34

Multiple Choice

Which of the following statements about the ALTER TABLE statement in SQL Server are true?

It can add constraints to an existing table. It can change the data type of an existing column. It can add new columns to an existing table.It can remove rows from a table.

The ALTER TABLE statement can add constraints, change column data types, and add new columns.

Q35

Multiple Choice

Which of the following actions cannot be performed using the ALTER TABLE statement in SQL Server?

Add a new column Change the data type of a column Remove rows from a tableAdd a CHECK constraint

The ALTER TABLE statement cannot be used to remove rows from a table.

Q36

Multiple Choice

Which of the following keywords are used with the ALTER TABLE statement to rename a table in SQL Server?

RENAME ALTER sp_renameCHANGE

The sp_rename system stored procedure is used to rename a table in SQL Server.

Q37

Multiple Choice

Which of the following statements about the ALTER TABLE statement in SQL Server are false?

It can add constraints to an existing table. It can change the data type of an existing column. It can add new columns to an existing table.It can drop a database.

The ALTER TABLE statement can add constraints, change column data types, and add new columns.

Q38

Multiple Choice

Which of the following actions can be performed using the ALTER TABLE statement in SQL Server?

Add a new column Change the data type of a column Drop a tableAdd a CHECK constraint

The ALTER TABLE statement can be used to add new columns, change column data types, and add constraints.

Q39

Multiple Choice

Which of the following keywords can be used with the ALTER TABLE statement to disable a constraint in SQL Server?

DISABLE NOCHECK REMOVEDROP

The NOCHECK keyword is used with the ALTER TABLE statement to disable a constraint.

Q40

Multiple Choice

Which of the following keywords can be used with the ALTER TABLE statement to enable a constraint in SQL Server?

ENABLE CHECK VALIDATEREENABLE

The CHECK keyword is used with the ALTER TABLE statement to enable a constraint.

Q41

Multiple Choice

Which of the following actions can be performed using the ALTER TABLE statement in SQL Server?

Add a new column Change the data type of a column Rename a columnDelete rows from a table

The ALTER TABLE statement can be used to add new columns, change column data types, and add constraints.

Q42

Multiple Choice

Which of the following keywords are used with the ALTER TABLE statement to change the collation of a column in SQL Server?

MODIFY COLLATION ALTER COLLATION CHANGE COLLATIONSET COLLATION

The ALTER COLUMN keyword is used with the ALTER TABLE statement to change the collation of a column.

Q43

Multiple Choice

Which of the following statements about the ALTER TABLE statement in SQL Server are true?

It can add constraints to an existing table. It can change the data type of an existing column. It can add new columns to an existing table.It can drop a table.

The ALTER TABLE statement can add constraints, change column data types, and add new columns.

Q44

Multiple Choice

Which of the following actions can be performed using the ALTER TABLE statement in SQL Server?

Add a new column Change the data type of a column Drop a constraintDrop a database

The ALTER TABLE statement can be used to add new columns, change column data types, and add constraints.

Q45

Multiple Choice

Which of the following keywords can be used with the ALTER TABLE statement to drop a constraint in SQL Server?

REMOVE DELETE DROPDISABLE

The DROP keyword is used with the ALTER TABLE statement to drop a constraint.

Microsoft SQL Server Database Quiz Questions