Structure of the CUSTOMERS table

-Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?
A) ALTER TABLE customers MODIFY lastname to last_name;
B) ALTER TABLE customers CHANGE lastname to last_name;
C) ALTER TABLE customers MODIFY (lastname,last_name);
D) none of the above

Question

Structure of the CUSTOMERS table
  ​
-Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?​
A) ALTER TABLE customers MODIFY lastname to last_name;​ 
B) ​ALTER TABLE customers CHANGE lastname to last_name; 
C) ​ALTER TABLE customers MODIFY (lastname,last_name); 
D) ​none of the above

Quizplus · Accepted Answer

The correct syntax to change a column name in SQL involves using the ALTER TABLE command followed by RENAME COLUMN, CHANGE, or similar, depending on the SQL dialect. None of the options provided correctly follow the syntax for any SQL dialect.

Structure of the CUSTOMERS Table