SQL Schema Modification MCQ ALTER Table Practice Questions

Direction: Choose the correct option

Which SQL command is used to modify database structure?

A. ALTER

B. CHANGE

C. UPDATE

D. MODIFY

Direction: Choose the correct option

ALTER TABLE customers ADD COLUMN phone VARCHAR(15);

What does this query do?

A. Drops phone column

B. Adds phone column

C. Modifies phone column

D. Adds phone table

Direction: Choose the correct option

How do you remove a column from an existing table?

A. ALTER TABLE ... DROP COLUMN

B. DELETE COLUMN ... FROM

C. ALTER TABLE ... REMOVE COLUMN

D. REMOVE COLUMN ... FROM

Direction: Choose the correct option

ALTER TABLE employees MODIFY COLUMN salary DECIMAL(12,2);

What is this doing?

A. Adding constraint

B. Dropping column

C. Changing column name

D. Changing column data type

Direction: Choose the correct option

ALTER TABLE students RENAME COLUMN name TO full_name;

What does this query accomplish?

A. Renames column

B. Renames table

C. Drops column

D. Adds new column

Quipoin Menu