Multiple Choice
In which of the following situations is the use of native dynamic SQL considered inappropriate?
A) The number and types of columns to be used is not known.
B) The number and type of bind variables is known.
C) You want to perform DDL.
D) You are executing the statement only once or twice.
Correct Answer:
Verified
Correct Answer:
Verified
Q37: _ are used to distinguish parameter values
Q38: Obfuscating or wrapping code refers to hiding
Q39: _ retrieves the data returned by a
Q40: The REQUEST_PIECES function is typically used to
Q41: The <u>UTL_LINE</u> package allows access to files
Q43: The _ package allows access to two
Q44: The array-like processing available in DBMS_SQL makes
Q45: The _ action of the DBMS_DDL package
Q46: The code fragment _ would raise an
Q47: DBMS_DDL.ALTER_COMPILE (<br>Type VARCHAR2,<br>Schema VARCHAR2,<br>Name VARCHAR2);<br>In the header