nerdexam
IBM

C2090-610 · Question #25

Which statement regarding triggers is true?

The correct answer is B. Triggers cannot be modified, they must be dropped and recreated with new definitions. See the full explanation below for the reasoning.

Question

Which statement regarding triggers is true?

Options

  • AOnly one INSERT, UPDATE, or DELETE trigger can be defined per table.
  • BTriggers cannot be modified, they must be dropped and recreated with new definitions.
  • CAdding a trigger to a table that already has rows in it will cause triggered actions to be fired.
  • DTriggers can only be fired one time per statement irrespective of the number of rows affected.

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    76% (31)
  • C
    7% (3)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice