MySQL Table Management Quiz

Modifying and managing database tables is an essential skill when working with MySQL. This quiz will test your knowledge of key concepts such as altering table structures, adding and deleting columns, renaming tables, and duplicating data. You will also explore how to safely modify table data while preserving constraints and avoiding errors. Answer the following questions to assess your understanding of updating and managing MySQL tables effectively.

If a table contains data and you attempt to shorten a column's length, what might happen?

An error will occur if data exceeds the new length

Only new rows will be affected

Data will be automatically truncated

The column will be shortened without issues

None

How can you duplicate a table in MySQL without copying its data?

CREATE TABLE new_table AS SELECT * FROM old_table;

COPY TABLE old_table TO new_table;

DUPLICATE TABLE old_table AS new_table;

CREATE TABLE new_table LIKE old_table;

None

What will the following SQL command do?

 ALTER TABLE product ADD on_sale BOOL;

Add a new column named ‘on_sale’ with a boolean data type

Modify an existing column named ‘on_sale’

Rename the table to ‘on_sale’

Delete the ‘on_sale’ column

None

Which SQL statement renames an existing table?

CHANGE TABLE

RENAME TABLE

MODIFY TABLE

ALTER TABLE RENAME TO

None

What happens to constraints like PRIMARY KEY when duplicating a table using the following statement?

CREATE TABLE new_table AS SELECT * FROM old_table;

Constraints are preserved

Only data is copied, constraints are lost

Indexes but not primary keys are copied

Only primary keys are preserved

None

Which SQL statement is used to modify the structure of an existing table?

ALTER TABLE

CHANGE TABLE

MODIFY TABLE

UPDATE TABLE

None

Which of the following is true about MySQL table modifications?

Renaming a table deletes its data

ALTER TABLE is used to modify tables

Tables cannot be modified after creation

Once a column is added, it cannot be removed

None

What is the correct way to change a column's data type?

ALTER TABLE product MODIFY price DECIMAL(10,2);

ALTER TABLE product CHANGE price DECIMAL(10,2);

RENAME COLUMN product.price DECIMAL(10,2);

UPDATE TABLE product SET price TYPE DECIMAL(10,2);

None

Which keyword is used to add a new column to a table?

ADD

INSERT

NEW COLUMN

MODIFY

None

10.

How can you rename a column in MySQL?

ALTER TABLE product CHANGE old_name new_name data_type;

MODIFY COLUMN old_name TO new_name;

UPDATE TABLE product SET COLUMN old_name = new_name;

RENAME COLUMN product.old_name TO new_name;

None

11.

What will happen if you run the following statement?

ALTER TABLE product DROP COLUMN discount;

All data in the ‘discount’ column will be cleared but the column remains

The column ‘discount’ will be removed from the ‘product’ table

The table will be deleted

An error will occur because columns cannot be deleted

None

12.

Which SQL statement permanently removes a table from the database?

REMOVE TABLE

DROP TABLE

TRUNCATE TABLE

DELETE TABLE

None

13.

Which keyword is used to move a column to a specific position in a table?

RELOCATE

MOVE

FIRST or AFTER

POSITION

None

14.

Which statement correctly copies all data from one table to another after duplicating its structure?

COPY TABLE old_table TO new_table;

INSERT INTO new_table SELECT * FROM old_table;

INSERT INTO new_table VALUES SELECT * FROM old_table;

REPLICATE TABLE old_table AS new_table;

None

15.

Which statement ensures that the duplicated table retains its structure, including constraints?

COPY TABLE old_table TO new_table;

CREATE TABLE new_table AS SELECT * FROM old_table;

BACKUP TABLE old_table TO new_table;

CREATE TABLE new_table LIKE old_table; INSERT INTO new_table SELECT * FROM old_table;

None

Enter your email address below if you would like to receive a copy of your quiz results.