Multiple choice

What is the equivalent of the old DROP TABLE command in Oracle Database 10g?

  1. DROP TABLE NO PURGE

  2. DROP TABLE works exactly the way it did in previous versions.

  3. DROP TABLE … PURGE

  4. DROP TABLE … TO BEFORE DROP
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle 10g, DROP TABLE by default moves tables to the recyclebin. The PURGE option drops the table permanently without sending it to the recyclebin, making it equivalent to pre-10g DROP TABLE behavior. DROP TABLE NO PURGE is not valid syntax, and DROP TABLE...TO BEFORE DROP is used for flashback recovery, not permanent deletion.

Keep practicing — related questions