nerdexam
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)
  • A
    5% (3)
  • B
    77% (43)
  • C
    4% (2)
  • D
    14% (8)

Community Discussion

No community discussion yet for this question.

Full 1Z0-050 Practice