Discuss PostgreSQL PGCES-02 Exam Topic 2 Question 73

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.

Suggested Answer: C, E

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

35 comments · newest first

Hyun 10 months ago

B is correct, triggers can be called on INSERT.

Evangelina 11 months ago

A and C are the wrong ones for sure!

Leila 11 months ago

Wait, are you sure about E? I thought rules aren't automatic.

Carma 11 months ago

Totally agree, C is definitely incorrect!

Carlota 11 months ago

Triggers don't work with SELECT statements.

Yuriko 12 months ago

I thought triggers could call functions before or after events, so option D should be correct, but I'm confused about the rules part in option E.

Melodie 12 months ago

I practiced a similar question, and I remember that triggers can only be set for INSERT, UPDATE, or DELETE, so option C seems wrong.

Dean 12 months ago

I'm not entirely sure about option E; I feel like I read something about rules and triggers being related, but I can't remember the details.

Gladis 1 year ago

I think option C is definitely incorrect because triggers don't activate on SELECT statements, right?

Claribel 1 year ago

I've got a good handle on triggers, so I think I can identify the incorrect statements here. I just need to carefully read through the options.

Dante 1 year ago

This question seems straightforward, but I want to double-check my understanding of triggers before answering.

Adrianna 1 year ago

Okay, let me think this through. I know triggers can be set up to fire before or after an event, but I'm not sure about the specific events like INSERT, UPDATE, and SELECT.

Paola 1 year ago

Hmm, I'm a bit unsure about this one. I know triggers can be used to call functions, but I'm not sure about the specifics of when they can be called.

Stephen 1 year ago

I'm pretty confident I can handle this question. The key is to identify the incorrect statements about triggers.

Matthew 2 years ago

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

Isaiah 2 years ago

↳ replying to Matthew

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

Glenn 2 years ago

↳ replying to Matthew

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

Reid 2 years ago

↳ replying to Matthew

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

Wai 2 years ago

↳ replying to Matthew

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

Lynelle 2 years ago

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

Ligia 2 years ago

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

Dion 2 years ago

↳ replying to Ligia

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

Magdalene 2 years ago

↳ replying to Ligia

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

Cathrine 2 years ago

↳ replying to Ligia

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

Evangelina 2 years 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.

Shonda 2 years ago

↳ replying to Evangelina

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

Cheryl 2 years ago

↳ replying to Evangelina

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

Louisa 2 years ago

↳ replying to Evangelina

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

Kanisha 2 years ago

↳ replying to Evangelina

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

Elliott 2 years ago

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

Donte 2 years 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.

Avery 2 years ago

↳ replying to Donte

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

Avery 2 years ago

↳ replying to Donte

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

Blossom 2 years ago

I agree with Thaddeus. Statement C is definitely incorrect.

Thaddeus 2 years ago

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

PostgreSQL PGCES-02 Exam - Topic 2 Question 73 Discussion