Oracle Database: Advanced PL/SQL — Question 6

Which statement is true about user-defined records?

Answer options

• A. They can be returned from a function.
• B. Field types must match column types.
• C. The number of fields must match the number of columns in a table.
• D. Field names must match selected column names.

Correct answer: A

Explanation

The correct answer is A because user-defined records can indeed be returned from functions, allowing for flexible data handling. Options B, C, and D are incorrect as they impose unnecessary constraints on user-defined records that do not apply in all scenarios.