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 theshared 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.
B D
B, D
b d
B,D
B,D
BD
Why not A?
The correct answer are B and D.
only privileges on the procedure and not on the table it is needed
BD