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.
Explanation:
a,c
A,C
A,C
A, C
The DBMS_SQL package provides an interface to use dynamic SQL to parse any data manipulation language (DML) or data definition language (DDL) statement using PL/SQL.
Dynamic SQL statements are not embedded in your source program; rather, they are stored in character strings that are input to, or built by, the program at runtime. This enables you to create more general-purpose procedures. For example, dynamic SQL lets you create a procedure that operates on a table whose name is not known until runtime.
YES A,C
A,C