Multiple Choice
Which of the following is the correct syntax for an EXECUTE IMMEDIATE statement?
A) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ];
B) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ]
C) EXECUTE IMMEDIATE 'SQL statement'
[ INTO ( var1, var2, ... | record ]
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
D) EXECUTE IMMEDIATE 'SQL statement'
[ USING [ IN | OUT | IN OUT ] bindvar1, bindvar2, ... ]
[ RETURNING | RETURN INTO outvar1, outvar2, ... ];
Correct Answer:

Verified
Correct Answer:
Verified
Q50: The util.ora file contains environment settings, such
Q51: In the DBMS_DDL package, _ is a
Q52: All of the following procedures are included
Q53: What is the goal of dynamic SQL?
Q54: The _ built-in package retrieves information about
Q56: _ establishes a work area for a
Q57: The <u>UTL_HTTP</u> package provides the capability to
Q58: Describe the basic mechanics of the alert
Q59: A(n) _ is a pointer to a
Q60: The basic mechanics of the alert process