Test Your MySQL ALTER TABLE Knowledge with This Quiz

Progress

Single Choice

Which of the following MySQL commands is used to add a new column to an existing table?

ADD COLUMN MODIFY COLUMN ALTER TABLERENAME TABLE

The ALTER TABLE statement in MySQL is used to add, delete, or modify columns in an existing table.

Single Choice

To change the data type of an existing column in MySQL, which clause of the ALTER TABLE statement is used?

MODIFY COLUMN CHANGE COLUMN ADD COLUMNDROP COLUMN

The MODIFY COLUMN clause is used to change the data type or properties of an existing column in MySQL.

Single Choice

Which of the following commands is used to rename a table in MySQL?

CHANGE TABLE MODIFY TABLE RENAME TABLEALTER TABLE

The ALTER TABLE statement is used in MySQL to rename a table using the RENAME TO clause.

Single Choice

How would you add a new column age of type INT to an existing MySQL table named users?

ALTER TABLE users ADD COLUMN age INT; MODIFY TABLE users ADD age INT; ADD COLUMN age INT TO users;ALTER users ADD age INT;

The correct syntax for adding a new column in MySQL is ALTER TABLE table_name ADD COLUMN column_name column_definition;.

Single Choice

Which statement would you use to drop the column age from the users table in MySQL?

ALTER TABLE users DROP age; ALTER TABLE users DROP COLUMN age; DELETE COLUMN age FROM users;REMOVE COLUMN age FROM users

To drop a column in MySQL, the correct syntax is ALTER TABLE table_name DROP COLUMN column_name;.

Single Choice

To change the name of an existing column from age to years in the users table, which MySQL command would you use?

ALTER TABLE users RENAME age TO years; MODIFY TABLE users CHANGE age TO years; ALTER TABLE users CHANGE age years INT;CHANGE COLUMN age TO years IN users;

The correct syntax to rename a column in MySQL is ALTER TABLE table_name CHANGE old_column_name new_column_name column_definition;

Single Choice

To add a UNIQUE constraint to the email column in the users table, which MySQL command would you use?

ALTER TABLE users ADD UNIQUE (email); ALTER TABLE users ADD UNIQUE email; ALTER TABLE users ADD CONSTRAINT UNIQUE (email);ALTER TABLE users ADD UNIQUE CONSTRAINT (email);

The correct syntax to add a UNIQUE constraint in MySQL is ALTER TABLE table_name ADD UNIQUE (column_name);.

Single Choice

How would you add a foreign key constraint to the order_id column in the orders table referencing the id column in the customers table?

ALTER TABLE orders ADD FOREIGN KEY (order_id) REFERENCES customers(id); ALTER TABLE orders ADD FOREIGN KEY order_id REFERENCES customers(id); ALTER TABLE orders ADD CONSTRAINT FOREIGN KEY (order_id) REFERENCES customers(id);ALTER TABLE orders ADD FOREIGN KEY (order_id) TO customers(id);

The correct syntax to add a foreign key constraint in MySQL is ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES referenced_table(referenced_column);.

Single Choice

Which MySQL command would you use to modify the price column in the products table to have a default value of 0.0?

ALTER TABLE products CHANGE price DECIMAL(10,2) DEFAULT 0.0; ALTER TABLE products MODIFY price DECIMAL(10,2) DEFAULT 0.0; ALTER TABLE products ALTER price SET DEFAULT 0.0;ALTER TABLE products SET DEFAULT price TO 0.0;

The correct syntax to modify a column to have a default value in MySQL is ALTER TABLE table_name MODIFY column_name column_definition DEFAULT default_value;.

Q10

Single Choice

In MySQL, to change the storage engine of a table named transactions to InnoDB, which of the following commands would you use?

ALTER TABLE transactions ENGINE = InnoDB; ALTER TABLE transactions SET ENGINE = InnoDB; ALTER TABLE transactions MODIFY ENGINE = InnoDB;ALTER TABLE transactions CHANGE ENGINE TO InnoDB;

The correct syntax to change the storage engine of a table in MySQL is ALTER TABLE table_name ENGINE = new_engine;.

Q11

True / False

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

True False

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

Q12

True / False

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

True False

The ALTER TABLE statement can rename a column using the CHANGE clause.

Q13

True / False

You can use the ALTER TABLE statement in MySQL to directly insert data into a table.

True False

The ALTER TABLE statement is used for altering the structure of a table, not for inserting data. Data insertion is done with the INSERT INTO statement.

Q14

True / False

In MySQL, to change the data type of a column, the ALTER TABLE statement can be used with the MODIFY COLUMN clause.

True False

The MODIFY COLUMN clause is used with the ALTER TABLE statement to change the data type or properties of an existing column.

Q15

True / False

MySQL allows adding multiple columns in a single ALTER TABLE statement.

True False

Multiple columns can be added in a single ALTER TABLE statement by listing each ADD COLUMN clause separated by commas.

Q16

True / False

To remove a primary key constraint from a column, you use the ALTER TABLE statement with the DROP PRIMARY KEY clause in MySQL.

True False

The ALTER TABLE statement with the DROP PRIMARY KEY clause is used to remove a primary key constraint from a table.

Q17

True / False

The ALTER TABLE statement in MySQL can be used to change the storage engine of a table.

True False

The ALTER TABLE statement can change the storage engine of a table using the ENGINE clause.

Q18

True / False

You can use the ALTER TABLE statement to add a foreign key constraint in MySQL without specifying the referenced table and column.

True False

When adding a foreign key constraint, the ALTER TABLE statement must specify the referenced table and column.

Q19

True / False

MySQL's ALTER TABLE statement can be used to rename an existing table.

True False

The ALTER TABLE statement can rename an existing table using the RENAME TO clause.

Q20

True / False

In MySQL, using the ALTER TABLE statement to add a unique constraint to a column will automatically index that column.

True False

Adding a unique constraint to a column using the ALTER TABLE statement will automatically create a unique index on that column in MySQL.

Q21

Multiple Choice

Identify the correct ALTER TABLE statement to add a new column to an existing table.

SQL Code

ALTER TABLE employees
ADD COLUMN department_id INT;

ALTER TABLE employees ADD COLUMN department_id INT; ALTER TABLE employees ADD department_id INT; ALTER TABLE employees MODIFY department_id INT;ALTER TABLE employees DROP COLUMN department_id;

This statement correctly adds a new column named department_id of type INT to the employees table.

Q22

Multiple Choice

Select the correct ALTER TABLE statement to change the data type of a column.

SQL Code

ALTER TABLE products
MODIFY COLUMN price DECIMAL(12, 2);

ALTER TABLE products MODIFY COLUMN price DECIMAL(12, 2); ALTER TABLE products CHANGE COLUMN price DECIMAL(12, 2); ALTER TABLE products ALTER COLUMN price DECIMAL(12, 2);ALTER TABLE products DROP COLUMN price DECIMAL(12, 2);

The MODIFY COLUMN clause allows you to change the data type or properties of an existing column.

Q23

Multiple Choice

Choose the correct ALTER TABLE statement to rename a column in a table.

SQL Code

ALTER TABLE customers
CHANGE COLUMN full_name name VARCHAR(100);

ALTER TABLE customers CHANGE COLUMN full_name name VARCHAR(100); ALTER TABLE customers RENAME COLUMN full_name TO name; ALTER TABLE customers MODIFY COLUMN full_name TO name VARCHAR(100);ALTER TABLE customers ALTER COLUMN full_name TO name;

The CHANGE COLUMN clause is used to rename a column while optionally changing its data type or other attributes.

Q24

Multiple Choice

Determine the correct ALTER TABLE statement to drop a column from a table.

SQL Code

ALTER TABLE orders
DROP COLUMN shipping_address;

ALTER TABLE orders DROP COLUMN shipping_address; ALTER TABLE orders REMOVE COLUMN shipping_address; ALTER TABLE orders DELETE COLUMN shipping_address;ALTER TABLE orders DROP shipping_address;

The DROP COLUMN clause is used to remove an existing column from a table.

Q25

Multiple Choice

Which ALTER TABLE statement correctly adds a UNIQUE constraint to a column?

SQL Code

ALTER TABLE users
ADD CONSTRAINT unique_email UNIQUE(email);

ALTER TABLE users ADD CONSTRAINT unique_email UNIQUE(email); ALTER TABLE users ADD UNIQUE(email); ALTER TABLE users MODIFY email UNIQUE;ALTER TABLE users ADD UNIQUE CONSTRAINT email;

The ADD CONSTRAINT clause allows you to add a new constraint to an existing column, ensuring that all values in the email column are unique.

Q26

Multiple Choice

Identify the correct ALTER TABLE statement to add a foreign key constraint.

SQL Code

ALTER TABLE orders
ADD CONSTRAINT fk_customer
FOREIGN KEY (customer_id)
REFERENCES customers(customer_id);

ALTER TABLE orders ADD CONSTRAINT fk_customer FOREIGN KEY (customer_id) REFERENCES customers(customer_id); ALTER TABLE orders ADD FOREIGN KEY (customer_id) REFERENCES customers(customer_id); ALTER TABLE orders ADD CONSTRAINT fk_customer_id FOREIGN KEY customer_id REFERENCES customers(customer_id);ALTER TABLE orders ADD CONSTRAINT FOREIGN KEY (customer_id) REFERENCES customers(customer_id);

This statement correctly adds a foreign key constraint named fk_customer that references the customer_id column in the customers table.

Q27

Multiple Choice

Select the correct ALTER TABLE statement to rename an existing table.

SQL Code

ALTER TABLE inventory
RENAME TO products_inventory;

ALTER TABLE inventory RENAME TO products_inventory; ALTER TABLE inventory CHANGE NAME TO products_inventory; ALTER TABLE inventory MODIFY NAME products_inventory;ALTER TABLE inventory RENAME inventory TO products_inventory;

The RENAME TO clause allows you to change the name of an existing table.

Q28

Multiple Choice

Determine the correct ALTER TABLE statement to add multiple columns to a table.

SQL Code

ALTER TABLE employees
ADD COLUMN department_id INT,
ADD COLUMN manager_id INT;

ALTER TABLE employees ADD COLUMN department_id INT, ADD COLUMN manager_id INT; ALTER TABLE employees ADD department_id INT ADD manager_id INT; ALTER TABLE employees ADD COLUMN department_id INT, manager_id INT;ALTER TABLE employees ADD department_id INT ADD COLUMN manager_id INT;

This statement correctly adds two new columns, department_id and manager_id, to the employees table.

Q29

Multiple Choice

Which ALTER TABLE statement correctly drops a UNIQUE constraint?

SQL Code

ALTER TABLE users
DROP INDEX unique_email;

ALTER TABLE users DROP INDEX unique_email; ALTER TABLE users DROP UNIQUE unique_email; ALTER TABLE users DROP CONSTRAINT unique_email;ALTER TABLE users DROP UNIQUE INDEX unique_email;

In MySQL, UNIQUE constraints are implemented as unique indexes. To drop a UNIQUE constraint, you use the DROP INDEX clause.

Q30

Multiple Choice

Choose the correct ALTER TABLE statement to modify multiple columns in a table.

SQL Code

ALTER TABLE employees
MODIFY COLUMN last_name VARCHAR(100),
MODIFY COLUMN first_name VARCHAR(100);

ALTER TABLE employees MODIFY COLUMN last_name VARCHAR(100), MODIFY COLUMN first_name VARCHAR(100); ALTER TABLE employees CHANGE COLUMN last_name VARCHAR(100), CHANGE COLUMN first_name VARCHAR(100); ALTER TABLE employees ALTER COLUMN last_name VARCHAR(100), ALTER COLUMN first_name VARCHAR(100);ALTER TABLE employees MODIFY last_name VARCHAR(100), MODIFY first_name VARCHAR(100);

This statement correctly modifies the data types of the last_name and first_name columns in the employees table.

MySQL Database Quiz Questions