oracle ocp 19c考題,科目082考試題(18)-unused column

unix_5030發表於2022-01-21

18、Evaluate the following ALTER TABLEstatement:

ALTER TABLE orders SET UNUSED (order_date);

Which statement is true?

A. After executing the ALTER TABLEcommand, you can add a new column called ORDER_DATE to the ORDERS table.

B. The ORDER_DATE column should be empty for the ALTER TABLE command to execute succsessfully.

C. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERStable.

D. The DESCRIBE command would still display the ORDER_DATE column.

Source : cuug


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70010796/viewspace-2853453/,如需轉載,請註明出處,否則將追究法律責任。

相關文章