You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?
A.
Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
B.
All the constraints defined on the table, except the referential integrity constraints, are flashed back.
C.
All the triggers associated with the table are flashed back but are disabled.
D.
Materialized views that use the CUSTOMERS table are flashed back.
E.
LOB segments associated with the CUSTOMERS table are flashed back.
BD
BE
BC
“If a table contains triggers, however, there are some special rules that apply when a Flashback Table operation is performed. All triggers are disabled during a Flashback Table operation. By default, they will remain disabled after the operation is complete, regardless
of whether the trigger was previously enabled or not.
If a table has one or more enabled triggers and you want them to remain enabled after the Flashback Table operation is complete, you can add the ENABLE TRIGGERS clause to the statement
> BC
All constraints are restored except for referential integrity constraints
“The retrieved indexes, triggers, and constraints have recycle bin names.”
When you drop a table, the materialized view aren’t place in recyclebin.. “the materialized view logs cannot be flashed back along with the table.”
BC