Multiple Choice
If the MAXRETAIL column of the PROMOTION table has been set as unused,which of the following commands is valid?
A) ALTER TABLE promotion RESET maxretail USED;
B) ALTER TABLE promotion DROP COLUMN maxretail;
C) ALTER TABLE promotion DROP UNUSED COLUMNS;
D) both b and c
Correct Answer:

Verified
Correct Answer:
Verified
Related Questions
Q77: The abbreviation for the DESCRIBE command is
Q78: Which of the following keywords is used
Q79: The USER_TAB_COLS data dictionary object contains a
Q80: You cannot delete the last column in
Q81: Which of the following SQL*Plus commands will
Q83: <u>Seven bytes</u> are allocated in a DATE
Q84: Which of the following symbols cannot be
Q85: To delete all the rows in a
Q86: The _ clause of the ALTER TABLE
Q87: The precision of a NUMBER does not