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%

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

Cristen

10 hours ago

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

upvoted 0 times

...