Which statements are true about PL/SQL procedures?

Which statements are true about PL/SQL procedures? (Choose all that apply.)

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.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


Oana

Oana

Why not A?

giosefer

giosefer

The correct answer are B and D.

giosefer

giosefer

only privileges on the procedure and not on the table it is needed