nerdexam
PostgreSQL_CE

PGCES-02 · Question #56

Select two incorrect statements regarding 'TRIGGER'.

The correct answer is C. When SELECT is executed to thetable, the specified function can be called. E. A corresponding rule is automatically created when a trigger is created. See the full explanation below for the reasoning.

Question

Select two incorrect statements regarding 'TRIGGER'.

Options

  • AWhen UPDATE is executed to thetable, the specified function can be called.
  • BWhen INSERT is executed to thetable, the specified function can be called.
  • CWhen SELECT is executed to thetable, the specified function can be called.
  • DA trigger can be set up to call a specified function before or after the event occurs.
  • EA corresponding rule is automatically created when a trigger is created.

How the community answered

(48 responses)
  • A
    2% (1)
  • B
    6% (3)
  • C
    79% (38)
  • D
    13% (6)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice