1z0-071 Oracle Database 12c SQL 第28题 SET UNUSED

Q28.  Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?
A. The DESCRIBE command would still display the ORDER_DATE column.
B. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
C. The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.

D. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.

Correct Answer: D