Oracle Database: Advanced PL/SQL — Question 54

Which is true about the PLSCOPE_SETTINGS parameter?

Answer options

• A. It is deprecated in Oracle 12c.
• B. It can be used to obtain information about all identifiers when compiling a procedure.
• C. It can be used to control execution of specific portions of the PL/SQL code conditionally.
• D. It can be used to control a user's privileges on PL/SQL objects at run time.

Correct answer: B

Explanation

The correct answer is B, as the PLSCOPE_SETTINGS parameter is specifically designed to provide information about all identifiers when a procedure is compiled. Option A is incorrect because while it is not actively deprecated, it is not the main focus in Oracle 12c. Options C and D do not accurately describe the functionality of PLSCOPE_SETTINGS.