nerdexam
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)
  • B
    6% (2)
  • C
    10% (3)
  • D
    84% (26)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice