Oracle
1Z0-147 · Question #22
1Z0-147 Question #22: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
Question
You have an AFTER UPDATE row-level trigger on the table EMP. This trigger queries the EMP table and inserts the updating user's information into the AUDIT_TABLE . What happens when the user updates rows on the EMP table?
Options
- AA compile time error occurs.
- BA runtime error occurs. The effect of trigger body and the triggering statement are rolled back.
- CA runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place.
- DThe trigger fires successfully. The update on the EMP table occurs, and data is inserted into the AUDIT_TABLE table.
- EA runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 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.