Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
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.
BDG Every explicit cursor and cursor variable has four attributes: %FOUND , %ISOPEN %NOTFOUND , and %ROWCOUNT
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"
For example update employees where job_id='PU_CLERK' will open an implict cursor for more than one row
BDG is right
BDG is right!
B,D,G is correct answer
B,D,G implicit cursor always closes after run
C is wrong. D is correct.
BDG is the right answer.