PostgreSQL Exam PGCES-02 Topic 8 Question 85 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 85
Topic #: 8

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;

ACURSOR

BSCROLL CURSOR WITH HOLD

CINSENSITIVE CURSOR

DNO SCROLL CURSOR WITH HOLD

ECURSOR WITHOUT HOLD

Show Suggested 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

12 days ago

I think D) NO SCROLL CURSOR WITH HOLD is the best option for this scenario.

upvoted 0 times

...

Justine

13 days ago

I'm not sure, but I think C) INSENSITIVE CURSOR could also work.

upvoted 0 times

...

Goldie

25 days 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

...

Emilio

1 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

1 months ago

I believe it should be B) SCROLL CURSOR WITH HOLD.

upvoted 0 times

...

Virgie

1 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

9 days ago

User 3: D) NO SCROLL CURSOR WITH HOLD

upvoted 0 times

...

Lucy

10 days ago

User 2: C) INSENSITIVE CURSOR

upvoted 0 times

...

Kanisha

16 days ago

User 1: B) SCROLL CURSOR WITH HOLD

upvoted 0 times

...

Janessa

1 months ago

I think the correct keyword is A) CURSOR.

upvoted 0 times

...

Suzan

1 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

Lindsey

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

4 days ago

I think the correct answer is B) SCROLL CURSOR WITH HOLD.

upvoted 0 times

...