PostgreSQL Exam PGCES-02 Topic 11 Question 75 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 75
Topic #: 11

[All PGCES-02 Questions]

The table "t1" is defined below. The column "id"

for table "t1" is of INTEGER type.

id | name ----

+-----------1 |

mammoth 2 |

tortoise 3 |

coelacanth

The following SQL statements were executed. Select the correct statement about the execution result. BEGIN; DECLARE c SCROLL CURSOR FOR SELECT name FROM t1 ORDER BY id;

MOVE FORWARD 2 FROM c; FETCH FORWARD ALL FROM c; COMMIT;

AThe number of rows returned by the FETCH statement is 0.

BThe number of rows returned by the FETCH statement is 1.

CThe number of rows returned by the FETCH statement is 2.

DThe number of rows returned by the FETCH statement is 3.

EAn error occurs part way through.

Show Suggested Answer

Suggested Answer: B

by Corazon at Sep 15, 2024, 11:55 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Julio

8 months ago

Oh man, cursors always trip me up. But I'm pretty sure the answer is C. Can't wait to be done with this exam and get back to my pet rock collection.

upvoted 0 times

Leigha

7 months ago

Definitely C, let's hope we're right.

upvoted 0 times

...

Annalee

7 months ago

I'm not sure, but C seems like the correct answer.

upvoted 0 times

...

Ernie

7 months ago

Yeah, I agree. C sounds right.

upvoted 0 times

...

Glenn

8 months ago

I think the answer is C.

upvoted 0 times

...

Virgina

8 months ago

I'm not sure, but I think the answer is C.

upvoted 0 times

...

Rasheeda

8 months ago

I agree with Pamella, the FETCH statement should return 1 row.

upvoted 0 times

...

Wilda

8 months ago

Hmm, I'm not so sure. The question mentions a SCROLL CURSOR, so I'm wondering if the cursor position can be reset somehow. Maybe the answer is D?

upvoted 0 times

...

Pamella

8 months ago

I think the correct answer is B.

upvoted 0 times

...

Kirk

8 months ago

I think the answer is C. The MOVE FORWARD 2 statement positions the cursor on the third row, and then the FETCH FORWARD ALL statement should return the remaining two rows.

upvoted 0 times

Kaycee

8 months ago

I believe it's A. The FETCH statement will return 0 rows because of an error in the execution.

upvoted 0 times

...

Latrice

8 months ago

I think it's B. The FETCH statement will return only 1 row after moving the cursor forward 2 positions.

upvoted 0 times

...

Cristen

8 months ago

I agree, the answer is C. The FETCH statement will return 2 rows after moving the cursor forward 2 positions.

upvoted 0 times

...