Exam 1z0-149 All QuestionsBrowse all questions from this exam
Question 21

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

    Correct Answer: B, D, G

    Implicit cursors are automatically created by the database whenever an SQL statement is executed, and they handle the opening, fetching, and closing operations implicitly. An implicit cursor generally returns only one record and is closed automatically after the query is executed. In contrast, explicit cursors are defined by the programmer and can return multiple records as they allow finer control over the cursor operations. The attributes %ISOPEN, %ROWCOUNT, %NOTFOUND, and %FOUND are associated with explicit cursors, enabling the programmer to check the state and outcome of explicit cursor operations. Therefore, the correct statements are: Explicit cursor can return more than one record, %ISOPEN, %ROWCOUNT, %NOTFOUND, and %FOUND are the attributes of explicit cursor, and %ISOPEN is always false in implicit cursor.

Discussion
FestoOptions: BDG

BDG Every explicit cursor and cursor variable has four attributes: %FOUND , %ISOPEN %NOTFOUND , and %ROWCOUNT

mattiamarraffa

Why A is wrong? "Implicit cursors are used in statements that return only one row. If the SQL statement returns more than one row, an error will occur"

Mcromeo

For example update employees where job_id='PU_CLERK' will open an implict cursor for more than one row

ISKVOptions: BDG

BDG is right

jfc1Options: BDG

B,D,G is correct answer

pmeyerOptions: BDG

BDG is right!

rpichuebasOptions: BDG

BDG is the right answer.

90e49c7

C is wrong. D is correct.

muradh8Options: BDG

B,D,G implicit cursor always closes after run