Question 159 You execute the following command after restarting the database instance: SQL> ALTER TABLE employees DROP COLUMNS CONTINUE; This command fails displaying the following error: ORA-12995: no columns in partially dropped state What could have caused the command to fail?
The table is in the valid state.
The column values in the EMPLOYEES table are being updated.
CONTINUE is not a valid option for the ALTER TABLE DROP COLUMNS command.
The columns of the EMPLOYEES table are set to UNUSED.
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?