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 PGCES-02 Exam - Topic 8 Question 85 Discussion

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;
B) SCROLL CURSOR WITH HOLD
A) CURSOR
C) INSENSITIVE CURSOR
D) NO SCROLL CURSOR WITH HOLD
E) CURSOR WITHOUT HOLD

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

0/2000 characters
Submit Cancel
Quentin
7 months ago
I'm surprised "NO SCROLL" is even an option, that won't work!
upvoted 0 times
...
Bulah
7 months ago
B is the right choice, it allows movement in any direction.
upvoted 0 times
...
Lottie
7 months ago
Definitely B, you need SCROLL CURSOR WITH HOLD for that.
upvoted 0 times
...
Ethan
7 months ago
Wait, does "WITH HOLD" really matter here?
upvoted 0 times
...
Sheldon
7 months ago
I think A is enough, CURSOR should work fine.
upvoted 0 times
...
Barb
8 months ago
I thought "INSENSITIVE CURSOR" was for when you want to see changes made by others, but I'm not sure if that's what we need here.
upvoted 0 times
...
Ulysses
8 months ago
I practiced a similar question, and I feel like "SCROLL CURSOR" was definitely part of it, but I can't remember if it was with or without hold.
upvoted 0 times
...
Viva
8 months ago
I'm not entirely sure, but I remember something about "WITH HOLD" being important for keeping the cursor active after a transaction.
upvoted 0 times
...
Elke
8 months ago
I think the cursor needs to be able to scroll, so maybe it's option B? That sounds familiar.
upvoted 0 times
...
Chu
9 months ago
I think the answer is B - SCROLL CURSOR WITH HOLD. That seems to match the description of being able to move the cursor in any direction and maintain the data even after the transaction ends. I'm pretty confident in that choice.
upvoted 0 times
...
Kaitlyn
9 months ago
I'm a bit confused on this one. There are a few different cursor options, and I'm not sure which one is the best fit for the requirements. I'll have to review my notes and try to reason through this.
upvoted 0 times
...
Quentin
9 months ago
Okay, I've got this. The answer is B - SCROLL CURSOR WITH HOLD. That will give me the ability to move the cursor in any direction and keep the data available even after the transaction is complete.
upvoted 0 times
...
Emilio
9 months ago
Hmm, I'm a little unsure about this one. I know we need to use a cursor, but I'm not sure which specific keyword to use. I'll have to think this through carefully.
upvoted 0 times
...
Francine
9 months ago
This looks like a pretty straightforward cursor question. I think the key is to identify the keywords that allow the cursor to move in any direction and reference data even after the end of the transaction.
upvoted 0 times
...
Laura
1 year ago
I think D) NO SCROLL CURSOR WITH HOLD is the best option for this scenario.
upvoted 0 times
...
Justine
1 year ago
I'm not sure, but I think C) INSENSITIVE CURSOR could also work.
upvoted 0 times
...
Goldie
1 year 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
1 year ago
User 3: B) SCROLL CURSOR WITH HOLD makes sense for sure.
upvoted 0 times
...
Kendra
1 year ago
User 2: A) CURSOR
upvoted 0 times
...
Carma
1 year ago
User 1: B) SCROLL CURSOR WITH HOLD
upvoted 0 times
...
...
Emilio
1 year 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
1 year ago
I believe it should be B) SCROLL CURSOR WITH HOLD.
upvoted 0 times
...
Virgie
1 year 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 year ago
User 3: D) NO SCROLL CURSOR WITH HOLD
upvoted 0 times
...
Lucy
1 year ago
User 2: C) INSENSITIVE CURSOR
upvoted 0 times
...
Kanisha
1 year ago
User 1: B) SCROLL CURSOR WITH HOLD
upvoted 0 times
...
...
Janessa
1 year ago
I think the correct keyword is A) CURSOR.
upvoted 0 times
...
Suzan
1 year 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
1 year ago
Great choice! SCROLL CURSOR WITH HOLD is the keyword you need for the cursor.
upvoted 0 times
...
Lindsey
1 year 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 year ago
I think the correct answer is B) SCROLL CURSOR WITH HOLD.
upvoted 0 times
...
...

Save Cancel