Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? A) The table is moved to the SYSAUX tablespace. B) The table is moved to the SYSTEM tablespace. C) The table is removed from the database permanently. D) The table is renamed and remains in the TBSFD tablespace.
Answer: D DROP TABLE的时候,只是给表重命名,表依然停留在原来的表空间,类似Windows的回收站。如果要彻底删除表,可以加上purge选项。
|