Which statements are true about PL/SQL procedures? (Choose all that apply.)
A.
Users with definer’s rights who are granted access to a procedure that updates a table must be
granted access to the table itself.
B.
Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server
avoids the parsing overhead of SQL statements at run time.
C.
Depending on the number of calls, multiple copies of the procedure are loaded into memory for
execution by multiple users to speed up performance.
D.
A PL/SQL procedure executing on the Oracle database can call an external procedure or
function that is written in a different programming language, such as C or Java.
Explanation:
b,d
B,D
i think that only D is correct
because………..
but please, give me yours opinion……..
despite occurred parsing light and heavy by the pl_sql engine of a pl / sql then loaded in the SGA, to each his recall, is rerun parsing light, certainly not more, that heavy, but every call to a sql statement richiame and activates the engine sql server that necessarily and independently performs, for each call, its parsing SQL.
isn’t it ?
NO you are wrong
B D.
B is advantage of pl sql, you can find it in the documentation
B,D
B,D