Deal of The Day! 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 8 Question 85 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 85
Topic #: 8
[All PGCES-02 Questions]

You want to create a cursor that will SELECT the "customer" table. The created cursor must be able to move in any direction and reference data even after the end of the transaction. Select one answer containing the correct keyword(s) to fill in the underlined blank below. DECLARE cursor1 __________ FOR SELECT * FROM customer;

Show Suggested Answer Hide Answer
Suggested Answer: B

by Olive at May 01, 2025, 11:36 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Laura
1 months ago
I think D) NO SCROLL CURSOR WITH HOLD is the best option for this scenario.
upvoted 0 times
...
Justine
1 months ago
I'm not sure, but I think C) INSENSITIVE CURSOR could also work.
upvoted 0 times
...
Goldie
2 months ago
B) SCROLL CURSOR WITH HOLD makes the most sense. I mean, who wants to be limited to just one direction, am I right?
upvoted 0 times
Weldon
19 days ago
User 3: B) SCROLL CURSOR WITH HOLD makes sense for sure.
upvoted 0 times
...
Kendra
21 days ago
User 2: A) CURSOR
upvoted 0 times
...
Carma
26 days ago
User 1: B) SCROLL CURSOR WITH HOLD
upvoted 0 times
...
...
Emilio
2 months ago
Haha, D) NO SCROLL CURSOR WITH HOLD? What kind of nonsense is that? Clearly, B) is the way to go.
upvoted 0 times
...
Kattie
2 months ago
I believe it should be B) SCROLL CURSOR WITH HOLD.
upvoted 0 times
...
Virgie
2 months ago
Hmm, I thought A) CURSOR was the answer, but I guess I was wrong. Oh well, back to the drawing board!
upvoted 0 times
Andree
1 months ago
User 3: D) NO SCROLL CURSOR WITH HOLD
upvoted 0 times
...
Lucy
1 months ago
User 2: C) INSENSITIVE CURSOR
upvoted 0 times
...
Kanisha
2 months ago
User 1: B) SCROLL CURSOR WITH HOLD
upvoted 0 times
...
...
Janessa
2 months ago
I think the correct keyword is A) CURSOR.
upvoted 0 times
...
Suzan
2 months ago
B) SCROLL CURSOR WITH HOLD is definitely the right answer. This allows me to move the cursor in any direction and retain the cursor even after the transaction is over.
upvoted 0 times
Tammy
30 days ago
Great choice! SCROLL CURSOR WITH HOLD is the keyword you need for the cursor.
upvoted 0 times
...
Lindsey
1 months ago
Yes, that's correct. It allows you to move the cursor in any direction and retain it after the transaction.
upvoted 0 times
...
Peggy
1 months ago
I think the correct answer is B) SCROLL CURSOR WITH HOLD.
upvoted 0 times
...
...

Save Cancel