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; ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.