The statement below was used to create a cursor named CSR1:DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF
Posted: Fri Aug 26, 2022 9:58 am
The statement below was used to create a cursor named CSR1:DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;When the cursor is opened, the result set contains six rows. After fetching all of the rows in the result set associated with cursor CSR1, application TEST1 needs to fetch the third row of the result set again.Which steps will allow application TEST1 to fetch the third row again?
A. FETCH ABSOLUTE 3
B. CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH
C. REOPEN csr1; FETCH; FETCH; FETCH;
D. FETCH PRIOR; FETCH PRIOR; FETCH PRIOR; FETCH PRIOR;
A. FETCH ABSOLUTE 3
B. CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH
C. REOPEN csr1; FETCH; FETCH; FETCH;
D. FETCH PRIOR; FETCH PRIOR; FETCH PRIOR; FETCH PRIOR;