Oracle
1Z0-141 · Question #123
1Z0-141 Question #123: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-141 to reveal the answer and full explanation for question #123. The question stem and answer options stay visible for context.
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?
Options
- APost-Commit
- BPost-Database-Commit
- CWhen-Validate-Record
- DPost-Insert, Post-Update and Post-Delete
- EYou cannot accomplish this using Forms triggers; you must use a database trigger.
Unlock 1Z0-141 to see the answer
You've previewed enough free 1Z0-141 questions. Unlock 1Z0-141 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.