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?()
- AThe table is moved to the SYSAUX tablespace.
- BThe table is moved to the SYSTEM tablespace.
- CThe table is removed from the database permanently.
- DThe table is renamed and remains in the TBSFD tablespace.