Which two statements are true about the effect of the command?

You execute this command to drop the ITEM table, which has the primary key referred in the

ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

You execute this command to drop the ITEM table, which has the primary key referred in the

ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command? (Choose two.)

A.
No flashback is possible to bring back the ITEM table

B.
The ORDERS table is dropped along with the ITEM table

C.
The dependent referential integrity constraints in the ORDERS table are disabled

D.
The dependent referential integrity constraints in the ORDERS table are removed

E.
The table definition of the ITEM table and associated indexes are placed in the recycle bin



Leave a Reply 2

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


Levijr

Levijr

“flashback table scott.item to before drop”??

ahmed

ahmed

The table and its dependent objects will remain in the recycle bin until they are purged from the recycle bin. You can explicitly purge a table or other object from the recycle bin with the SQL*Plus PURGE statement,