PostgreSQL_CE
PGCES-02 · Question #142
PGCES-02 Question #142: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #142. The question stem and answer options stay visible for context.
Question
The table "t1" is defined below. The column "id" for table "t1" is of INTEGER type. id | name ----+------------ 1 | mammoth 2 | tortoise 3 | coelacanth PostgreSQL CE PGCES-02 Exam 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;
Options
- 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 rowsreturned by the FETCH statement is 2.
- DThe number of rowsreturned by the FETCH statement is 3.
- EAn error occurs part way through.
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.