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?

Question

Options

• AOnly the primary key constraint created for the table is flashed back, whereas all other indexes
• BAll the constraints defined on the table, except the referential integrity constraints, are flashed
• CAll the triggers associated with the table are flashed back but are disabled.
• DMaterialized views that use the CUSTOMERS table are flashed back.
• ELOB segments associated with the CUSTOMERS table are flashed back.

• A
  3% (1)
• B
  86% (30)
• C
  3% (1)
• D
  9% (3)

Explanation

B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that Incorrect Answers: A: Flashback Table restores tables while automatically maintaining associated attributes such as current indexes, triggers, and constraints, and in this way enabling you to avoid finding and restoring database- specific properties. Furthermore. indexes on table that exist currently are reverted and reflect the state of the table at the Flashback point. C: By default, the database disables triggers on the affected table before performing a FLASHBACK TABLE operation. After the operation, the database returns the triggers to the state they were in before the operation (enabled or disabled). To keep triggers enabled during the flashback of the table, add an ENABLE TRIGGERS clause to the FLASHBACK TABLE D: Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions. 2017), page 18-11

No community discussion yet for this question.