What happens in this scenario?

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?

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 SYSTEM tablespace.

B.
The table is renamed and remains in the TBSFD tablespace.

C.
The table is moved to the SYSAUX tablespace.

D.
The table is removed from the database permanently.



Leave a Reply 0

Your email address will not be published. Required fields are marked *