Oracle Database 11g: Program with PL/SQL — Question 65

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

Answer options

• 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

Correct answer: B, D

Explanation

Option B is correct because reusing parsed PL/SQL code in the shared SQL area minimizes the need for parsing SQL statements at runtime, leading to improved performance. Option D is also accurate as PL/SQL can indeed call external procedures or functions in other programming languages. Options A and C are incorrect; access to the underlying table is not required for users with definer's rights, and multiple copies of a procedure are not loaded into memory as it is executed in a shared manner.