Question

Which of the following commands will change the name of the PROMOTION table to GIFT?

A.ALTER TABLE promotion NAME TO gift
B.ALTER TABLE promotion TO gift;
C.RENAME TABLE promotion TO gift;
D.ORENAME promotion TO gift

Answer 1

The correct command to change the name of the PROMOTION table to GIFT is RENAME TABLE promotion TO gift;

Step-by-step explanation:

The correct command to change the name of the PROMOTION table to GIFT is OPTION C - RENAME TABLE promotion TO gift;.

The ALTER TABLE statement is used to modify the structure of a table, but it does not allow for changing the table name itself. In contrast, the RENAME TABLE statement is specifically used for renaming tables.

Therefore, by using the RENAME TABLE statement and specifying the current table name (promotion) and the new desired name (gift), the table name will be changed to GIFT.