Oracle Application Express 5: Developing Web Applications — Question 49

Rick has created an "editable" interactive grid on a table that includes four audit columns: CREATED, CREATED_BY, UPDATED, and UPDATED_BY.
The four audit columns are included in the report with read-only type set to Always.
How can Rick update all four audit columns when a user inserts a row, and the UPDATED and UPDATED_BY columns when a user updates a row?

Answer options

• A. using "Enable" Dynamic Actions
• B. using default values on the report columns
• C. using After Header Computations
• D. defining an After Submit process

Correct answer: A

Explanation

The correct answer is A because 'Enable' Dynamic Actions can trigger updates to the audit columns during insert and update events. Options B and C are not appropriate as they do not provide a mechanism for updating these columns dynamically. Option D could work for updates, but would not cover the requirement to update all four columns on insert.