The RECYCLEBIN parameter is set to ON for your database. You drop a table,
PRODUCTS, from the SCOTT schema.
Which two statements are true regarding the outcome of this action? (Choose two)
A.
All the related indexes and views are automatically dropped
B.
The flashback drop feature can recover only the table structure
C.
Only the related indexes are dropped whereas views are invalidated
D.
The flashback drop feature can recover both the table structure and its data
C and D are correct:
for C: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm
All views and PL/SQL program units dependent on a dropped table remain, yet become invalid (not usable). See “Managing Object Dependencies” for information about how the database manages dependencies.
for D: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm
When you drop a table, the database does not immediately remove the space associated with the table. Instead, the table is renamed and, along with any associated objects, it is placed in the Recycle Bin of the database. The Flashback Drop operation recovers the table from the recycle bin.