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 audit_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?

Question

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 audit_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?

Accepted Answer

D. Post-Insert, Post-Update and Post-Delete

Answer

A. Post-Commit

Answer

B. Post-Database-Commit

Answer

C. When-Validate-Record

Answer

E. You cannot accomplish this using Forms triggers; you must use a database trigger.

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…

Question

Options

How the community answered

Community Discussion