Examine the following block of code:
Which two statements are correct about the code above? (Choose two.)
A. The function goes through only the parse and executes phases.
B. The function goes through the parse, bind, and execute phases.
C. The function goes through the parse, bind, execute, and fetch phases.
D. All the processing phases for the function are performed only at run time.
E. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Looks like AE are correct answers
Explanation/Reference:
Reference: http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_sqlproc.htm#BEJDDEHE
B, C are not correct because:
“If the statement is a query, fetch its rows.” – Delete doesn’t require fetch
p_table_name and p_empno are not bind variables