Oracle
1Z0-050 · Question #3
Which statement describes the effect of table redefinition on the triggers attached to the table?
The correct answer is B. All triggers on the table are invalidated and are automatically revalidated with the next DML. See the full explanation below for the reasoning.
Question
Which statement describes the effect of table redefinition on the triggers attached to the table?
Options
- AAll triggers on the table remain valid.
- BAll triggers on the table are invalidated and are automatically revalidated with the next DML
- CAll triggers on the table are invalidated and must be manually recompiled before the next DML
- DOnly triggers that are affected by the changes to the structure of the table are invalidated and
How the community answered
(56 responses)- A5% (3)
- B77% (43)
- C4% (2)
- D14% (8)
Community Discussion
No community discussion yet for this question.