Oracle Application Express 5: Developing Web Applications — Question 60

Which two actions can be done by a Page Process of type Automatic Row Processing (DML)? (Choose two.)

Answer options

• A. Perform automatic detection of lost updates.
• B. Perform CRUD operations on multiple tables.
• C. Log a user-defined message when an exception is raised.
• D. Apply a SQL WHERE clause to append to all generated INSERT, UPDATE, and DELETE statements at run time.
• E. generate a primary key column value on a SQL INSERT statement.
• F. Invoke PL/SQL code to perform the inserts, updates, and deletes.

Correct answer: D, F

Explanation

The correct answers, D and F, are accurate because an Automatic Row Processing (DML) Page Process can indeed apply a SQL WHERE clause dynamically and invoke PL/SQL code to manage data modifications. Options A, B, C, and E do not correctly reflect the capabilities of this process type, as they either describe unrelated functionalities or are too broad.