PostgreSQL Exam PGCES-02 Topic 2 Question 73 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 73
Topic #: 2

[All PGCES-02 Questions]

Select two incorrect statements regarding 'TRIGGER'.

AWhen UPDATE is executed to the table, the specified function can be called.

BWhen INSERT is executed to the table, the specified function can be called.

CWhen SELECT is executed to the table, 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.

Show Suggested Answer

Suggested Answer: C, E

by Herminia at Sep 18, 2024, 04:28 PM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Matthew

2 months ago

I bet the answer is B and C. Triggers are meant to fire on INSERT and UPDATE, not SELECT. Easy peasy!

upvoted 0 times

Isaiah

8 days ago

Exactly, triggers can be set up to call a specified function before or after INSERT or UPDATE events.

upvoted 0 times

...

Glenn

11 days ago

So, the incorrect statements would be B and C, since triggers do not fire on SELECT operations.

upvoted 0 times

...

Reid

14 days ago

That's correct, triggers are used to perform actions before or after INSERT and UPDATE operations.

upvoted 0 times

...

Wai

1 months ago

I think you're right, triggers are meant to fire on INSERT and UPDATE.

upvoted 0 times

...

Lynelle

2 months ago

Haha, this question is like a trigger trap! You really need to know your trigger fundamentals to nail this one.

upvoted 0 times

...

Ligia

2 months ago

I'm pretty sure A, B, and D are all correct statements about triggers. C is the only one that seems off.

upvoted 0 times

Dion

1 months ago

User 3: So, the incorrect statements are C and E.

upvoted 0 times

...

Magdalene

1 months ago

User 2: I agree, C is the incorrect statement.

upvoted 0 times

...

Cathrine

1 months ago

I think A, B, and D are correct about triggers.

upvoted 0 times

...

Evangelina

2 months ago

Whoa, E is a tricky one. I don't think a rule is automatically created when a trigger is set up. That feels like a trick question.

upvoted 0 times

Shonda

1 months ago

D) A trigger can be set up to call a specified function before or after the event occurs.

upvoted 0 times

...

Cheryl

1 months ago

I agree, E does seem like a trick question. It's not correct.

upvoted 0 times

...

Louisa

2 months ago

E) A corresponding rule is automatically created when a trigger is created.

upvoted 0 times

...

Kanisha

2 months ago

A) When UPDATE is executed to the table, the specified function can be called.

upvoted 0 times

...

Elliott

2 months ago

I believe statement E is also incorrect because a trigger does not automatically create a corresponding rule.

upvoted 0 times

...

Donte

3 months ago

Hmm, I think C is definitely incorrect. A trigger shouldn't be fired on a SELECT statement. The purpose of a trigger is to capture INSERT and UPDATE events, not SELECT.

upvoted 0 times

Avery

2 months ago

Yes, triggers are meant for INSERT and UPDATE events, not SELECT. C is definitely incorrect.

upvoted 0 times

...

Avery

2 months ago

I agree, C is incorrect. Triggers are not fired on SELECT statements.

upvoted 0 times

...

Blossom

3 months ago

I agree with Thaddeus. Statement C is definitely incorrect.

upvoted 0 times

...

Thaddeus

3 months ago

I think statement C is incorrect because SELECT does not trigger a function.

upvoted 0 times

...