Oracle Database 12c: Advanced Administration — Question 158

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?

Answer options

• 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.

Correct answer: B, E

Explanation

The correct answer is B and E because when using FLASHBACK TABLE, all constraints except referential integrity constraints are restored, and LOB segments are also recovered. Options A, C, and D are incorrect as they misrepresent the behavior of the FLASHBACK TABLE command regarding constraints, triggers, and materialized views.