Home » PL/SQL MCQs

What is TRUE about %ISOPEN in PL/SQL Cursor?

83. What is TRUE about %ISOPEN in PL/SQL Cursor?

1. If any DML statement, such as INSERT, DELETE or UPDATE, effects one or more rows, or if a SELECT INTO statement returns at least one row, this method returns TRUE.
2. A SELECT INTO statement or DML statements like INSERT, DELETE, AND UPDATE do not result in any rows being affected.
3. Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.
4. Results are returned for DML statements such as inserting, deleting, and updating records, or for those returned by a SELECT INTO command.

Answer: C) Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors

Explanation:

In the case of %ISOPEN, Because SQL cursors are automatically closed after execution of their associated SQL statements, the function always returns FALSE for implicit cursors.