Oracle
1Z0-071 · Question #73
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. 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
- DAfter executing the ALTER TABLE command, you can add a new column called ORDER_DATE
How the community answered
(46 responses)- A11% (5)
- B4% (2)
- C2% (1)
- D83% (38)
Community Discussion
No community discussion yet for this question.