What happens in this scenario?

Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

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