BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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

Show Suggested Answer Hide 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
28 days 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
Wai
11 days ago
I think you're right, triggers are meant to fire on INSERT and UPDATE.
upvoted 0 times
...
...
Lynelle
30 days 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 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
10 days ago
User 3: So, the incorrect statements are C and E.
upvoted 0 times
...
Magdalene
13 days ago
User 2: I agree, C is the incorrect statement.
upvoted 0 times
...
Cathrine
15 days ago
I think A, B, and D are correct about triggers.
upvoted 0 times
...
...
Evangelina
1 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
9 days ago
D) A trigger can be set up to call a specified function before or after the event occurs.
upvoted 0 times
...
Cheryl
11 days ago
I agree, E does seem like a trick question. It's not correct.
upvoted 0 times
...
Louisa
27 days ago
E) A corresponding rule is automatically created when a trigger is created.
upvoted 0 times
...
Kanisha
28 days 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
2 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
1 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
2 months ago
I agree with Thaddeus. Statement C is definitely incorrect.
upvoted 0 times
...
Thaddeus
2 months ago
I think statement C is incorrect because SELECT does not trigger a function.
upvoted 0 times
...

Save Cancel