Where the DBMS_SQL package should be used. (Choose two.)

Identify two situations where the DBMS_SQL package should be used. (Choose two.)
A. The SELECT list is not known until run time.
B. The dynamic SQL statement retrieves rows into records.
C. You do not know how many columns a select statement will return, or what their data types will.
D. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

Download Printable PDF. VALID exam to help you PASS.

One thought on “Where the DBMS_SQL package should be used. (Choose two.)

  1. I also think correct answers are AC:

    https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/dynamic.htm#LNPLS01108

    “You must use the DBMS_SQL package to run a dynamic SQL statement when you do not know either of these until run time:
    SELECT list
    What placeholders in a SELECT or DML statement must be bound

    In these situations, you must use native dynamic SQL instead of the DBMS_SQL package:
    The dynamic SQL statement retrieves rows into records.
    You want to use the SQL cursor attribute %FOUND, %ISOPEN, %NOTFOUND, or %ROWCOUNT after issuing a dynamic SQL statement that is an INSERT, UPDATE, DELETE, MERGE, or single-row SELECT statement.”

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.