Explanation:
Once the ALTER TABLE DROP COLUMN statement is issued, Oracle removes the column from the table immediately. Other choices are all incorrect because they indicate that the column will be removed at some later point when another command is issued, which is not the case for the ALTER TABLE DROP COLUMN command shown in the Question:.
Reference:
Oracle 9i: Administrator’s Guide
Oracle 9i: Concepts

---