Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Exam Prep Questions

1:

You were in the process of dropping the invoice_number column in the orders table. The table was marked as invalid while the command was processing. While the column drop was in process, suddenly the instance failed. You restart the instance and notice that the orders table is still invalid. You want to be able to access the data in the table and finish the drop column that you had in process at the failure point. What could you do? [check all that apply] A. Reissue the ALTER TABLE orders DROP COLUMN invoice_number command. B. Issue the ALTER TABLE orders DROP COLUMNS CONTINUE command. C. Truncate the table. D. Drop the table and start over fresh. E. Mark the column as unused and worry about it later.

A1:

Answer B is correct; ...