Oracle Database: Advanced PL/SQL — Question 37

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

Answer options

• A. It can be used in the declaration of object types.
• B. It must be specified in the heading of a package specification.
• C. The check is enforced by this clause for direct access and access through dynamic SQL.
• D. It can be used for individual procedures and functions declared in a package specification.
• E. It must be specified in the heading of a package body.

Correct answer: A, D

Explanation

Option A is correct because the ACCESSIBLE BY clause can indeed be used when defining object types. Option D is also correct, as this clause can apply to individual procedures and functions within a package specification. Options B, C, and E are incorrect because they either misstate the requirement for the clause or its enforcement mechanism.