Oracle Database SQL — Question 3

You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)

Answer options

• A. It will remove the DEPARTMENTS table from the database.
• B. It will drop all indexes on the DEPARTMENTS table.
• C. It will remove all views that are based on the DEPARTMENTS table.
• D. It will remove all synonyms for the DEPARTMENTS table.
• E. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
• F. It will delete all rows from the DEPARTMENTS table, but retain the empty table.

Correct answer: A, B, E

Explanation

The correct answer A is true because the DROP TABLE command does indeed remove the specified table from the database. Option B is also correct since dropping the table automatically removes all indexes associated with it. Option E is valid because using PURGE means that the operation cannot be rolled back, and the table cannot be recovered. Options C, D, and F are incorrect because dropping the table does not directly affect views or synonyms, nor does it retain an empty table.