386th questions, 053386
386. You have just successfully med a flashback table operation using the following command:
Flashback table employees to scn 123456;
The employees table has triggers associated with it. Which of the following statements is true regarding
The state of the triggers during the Flashback Table operation?
A. All the triggers are disabled.
B. All the triggers are enabled by default.
C. Enabled triggers remain enabled and disabled triggers remain disabled.
D. Triggers are deleted when a Flashback Table operation is already med.
Answer:A
By default, the database disables triggers on the affected table before discoveryFLASHBACK 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, addENABLE TRIGGERS
Clause toFLASHBACK TABLE
Statement
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.