Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?
A) ALTER TABLE promotion SET UNUSED (minretail);
B) ALTER TABLE promotion SET minretail UNUSED;
C) ALTER TABLE promotion SET UNUSED COLUMN minretail;
D) both a and c

Question

​Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?
A) ​ALTER TABLE promotion SET UNUSED (minretail);
B) ​ALTER TABLE promotion SET minretail UNUSED;
C) ​ALTER TABLE promotion SET UNUSED COLUMN minretail;
D) ​both a and c

Quizplus · Accepted Answer

The correct syntax to mark a column as unused in Oracle SQL is either "ALTER TABLE table_name SET UNUSED (column_name);" or "ALTER TABLE table_name SET UNUSED COLUMN column_name;". Therefore, both options A and C are correct, making D the correct choice.

​Which of the Following Commands Will Set the MINRETAIL Column

Which of the Following Commands Will Set the MINRETAIL Column