Oracle Application Express 5: Developing Web Applications — Question 48

David has created Page 10 as a form page using an Automatic Row Fetch process. A column named LOCATION has been added to the underlying table, and the form needs to include this new column.
You decide to copy an existing page item :P10_DEPTNO and use that to represent the LOCATION column.
Which is the minimum action required on the copied item to get the form working correctly?

Answer options

• A. Update the item label.
• B. Set value required to No.
• C. Update the item name.
• D. Change the source type to NULL.
• E. Set the source database column to LOCATION.

Correct answer: D

Explanation

The correct answer is D because changing the source type to NULL allows the system to recognize that the item should not retrieve any value from the database. The other options do not address the need for the source type to be properly configured for the new LOCATION column.