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

3 months ago

B is correct, triggers can be called on INSERT.

upvoted 0 times

...

Evangelina

3 months ago

A and C are the wrong ones for sure!

upvoted 0 times

...

Leila

3 months ago

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

upvoted 0 times

...

Carma

4 months ago

Totally agree, C is definitely incorrect!

upvoted 0 times

...

Carlota

4 months ago

Triggers don't work with SELECT statements.

upvoted 0 times

...

Yuriko

4 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

4 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

4 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

5 months ago

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

upvoted 0 times

...

Claribel

5 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

5 months ago

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

upvoted 0 times

...

Adrianna

5 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

5 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

5 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

1 year 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

1 year ago

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

upvoted 0 times

...

Reid

1 year ago

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

upvoted 0 times

...

Wai

1 year ago

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

upvoted 0 times

...

Lynelle

1 year 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

1 year 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 year ago

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

upvoted 0 times

...

Magdalene

1 year ago

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

upvoted 0 times

...

Cathrine

1 year ago

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

upvoted 0 times

...

Evangelina

1 year 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 year ago

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

upvoted 0 times

...

Cheryl

1 year ago

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

upvoted 0 times

...

Louisa

1 year ago

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

upvoted 0 times

...

Kanisha

1 year ago

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

upvoted 0 times

...

Elliott

1 year ago

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

upvoted 0 times

...

Donte

1 year 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