You are developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLOYEES table. You are also maintaining an audit table with the following table description
SQL>desc audlt changes
Name Null? Type
—————————— ——– — ——— —————————– TABLE NAME VARCHAR2 (30)
ID NUMBER
TIMESTAMP DATE
CHANGE BY VARCHAR2 (30)
CHANGE TYPE VARCHAR2 (6)
Valid values for the CHANGE _TYPE column are INSERT, UPDATE, and DELETE.
Which trigger(s) must you create or modify in the Human Resources form to track all the information in the audit table?
A.
Post-Commit
B.
Post-Data base-Commit
C.
When-Validate-Record
D.
Post-Insert, Post-Update and Post-Delete
E.
You cannot accomplish this using Forms triggers; you must use a database trigger