Oracle Database: Advanced PL/SQL — Question 1

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

Answer options

• A. PACKAGES
• B. VARIABLES
• C. ANONYMOUS BLOCK
• D. TRIGGER BODY
• E. DATABASE LINKS

Correct answer: A, B

Explanation

The correct answers are A and B because PACKAGES and VARIABLES can be deprecated in PL/SQL using the DEPRECATE pragma, signaling to developers that these elements are no longer recommended for use. The other options, such as ANONYMOUS BLOCK, TRIGGER BODY, and DATABASE LINKS, do not support deprecation through this pragma.