Oracle Database: Program with PL/SQL — Question 51

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

Answer options

• A. CREATE < function/Procedure> PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’ AS …
• B. ALTER SYSTEM SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
• C. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
• D. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
• E. ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’

Correct answer: A, D

Explanation

The correct answers are A and D because they enable the collection of identifier data in PL/SQL. Option A sets the PLSCOPE_SETTINGS for a function or procedure to collect all identifiers, while option D does the same for the current session. Options B and C disable identifier collection, and option E is incorrectly formatted for the context.