Oracle Application Express 5: Developing Web Applications — Question 2

Which is true about interactive reports?

Answer options

• A. Interactive reports can be either read-only or editable.
• B. All columns defined in the report query must be shown.
• C. You can define only one interactive report on a page.
• D. An interactive report can be based on a PL/SQL function body returning a SQL query.

Correct answer: A

Explanation

The correct answer is A because interactive reports can indeed be configured to allow both read-only and editable views. Option B is incorrect as not all columns need to be displayed; option C is false because multiple interactive reports can exist on a single page; option D is misleading since interactive reports can be based on various data sources, not just a PL/SQL function.