Oracle Application Express 5: Developing Web Applications — Question 9

John is evaluating an old APEX application that has over 20 tabular forms. He wants to update the application and replace all of the tabular forms with interactive grids.
What is the fastest way for John to replace the old reports?

Answer options

• A. Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new interactive grid.
• B. Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
• C. Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid", select all, and then click Upgrade.
• D. Go to each report and change the type from Tabular Form to Interactive Grid.

Correct answer: D

Explanation

The correct answer is D, as it directly allows for a simple change of the report type from Tabular Form to Interactive Grid without the need for creating new pages or copying SQL. Options A and B involve more manual work and steps, while option C is not applicable since the upgrade utility does not exist for this specific scenario in standard APEX functionality.