Oracle
1Z0-047 · Question #96
Evaluate the following ALTER TABLE statement: ALTER TABLE orders SET UNUSED order_date; Which statement is true?
The correct answer is D. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the. See the full explanation below for the reasoning.
Question
Evaluate the following ALTER TABLE statement:
ALTER TABLE orders SET UNUSED order_date; Which statement is true?
Options
- AThe DESCRIBE command would still display the ORDER_DATE column.
- BROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
- CThe ORDER_DATE column should be empty for the ALTER TABLE command to execute successfully.
- DAfter executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the
How the community answered
(31 responses)- B6% (2)
- C10% (3)
- D84% (26)
Community Discussion
No community discussion yet for this question.