nerdexam
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)
  • A
    11% (5)
  • B
    4% (2)
  • C
    2% (1)
  • D
    83% (38)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice