Oracle Database: Advanced PL/SQL — Question 48

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

Answer options

• A. a record declared in an anonymous block
• B. a record declared in a procedure
• C. an associative array indexed by PLS_INTEGER
• D. a record declared in a package specification
• E. a predefined PL/SQL-only data type like BOOLEAN
• F. an associative array indexed by VARCHAR2

Correct answer: C, D, F

Explanation

The correct answers are C, D, and F because they represent PL/SQL-only data types that can be used in queries and native dynamic SQL. Options A and B are incorrect as records declared in an anonymous block and a procedure are not accessible outside their scopes, making them unsuitable for this context. Option E is not applicable as BOOLEAN is not usable in SQL queries.