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.
Explanation:
a,e
a,e
D,E since the function is not executed anywhere.
you are wrong, tead documentation about processing ddl statements
to create function you need execute CODE for it, but not to execute function
A,E
D,E
D,E
A,B,C is not correct – function doesn’t go through the parse. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time. So E excludes A.
Benefits of Stored Procedures and Functions:
Improved performance
– Avoid reparsing for multiple users by exploiting the shared SQL area
– Avoid PL/SQL parsing at run time by parsing at compile time
A,E correct
avoid reparsing after it is parsed when created
AE