PostgreSQL PGCES-02 Exam - 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

Hyun

6 months ago

B is correct, triggers can be called on INSERT.

upvoted 0 times

...

Evangelina

6 months ago

A and C are the wrong ones for sure!

upvoted 0 times

...

Leila

6 months ago

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

upvoted 0 times

...

Carma

7 months ago

Totally agree, C is definitely incorrect!

upvoted 0 times

...

Carlota

7 months ago

Triggers don't work with SELECT statements.

upvoted 0 times

...

Yuriko

7 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.

upvoted 0 times

...

Melodie

7 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.

upvoted 0 times

...

Dean

7 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.

upvoted 0 times

...

Gladis

8 months ago

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

upvoted 0 times

...

Claribel

8 months 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.

upvoted 0 times

...

Dante

8 months ago

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

upvoted 0 times

...

Adrianna

8 months 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.

upvoted 0 times

...

Paola

8 months 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.

upvoted 0 times

...

Stephen

8 months ago

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

upvoted 0 times

...

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!

upvoted 0 times

Isaiah

1 year ago

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

upvoted 0 times

...

Glenn

2 years ago

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

upvoted 0 times

...

Reid

2 years ago

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

upvoted 0 times

...

Wai

2 years ago

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

upvoted 0 times

...

Lynelle

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

2 years ago

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

upvoted 0 times

...

Magdalene

2 years ago

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

upvoted 0 times

...

Cathrine

2 years ago

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

upvoted 0 times

...

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.

upvoted 0 times

Shonda

2 years ago

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

upvoted 0 times

...

Cheryl

2 years ago

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

upvoted 0 times

...

Louisa

2 years ago

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

upvoted 0 times

...

Kanisha

2 years ago

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

upvoted 0 times

...

Elliott

2 years ago

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

upvoted 0 times

...

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.

upvoted 0 times