Oracle
1Z0-147 · Question #27
1Z0-147 Question #27: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.
Question
You have a row level BEFORE UPDATE trigger on the EMP table. This trigger contains a SELECT statement on the EMP table to ensure that the new salary value falls within the minimum and maximum salary for a given job title. What happens when you try to update a salary value in the EMP table?
Options
- AThe trigger fires successfully.
- BThe trigger fails because it needs to be a row level AFTER UPDATE trigger.
- CThe trigger fails because a SELECT statement on the table being updated is not allowed.
- DThe trigger fails because you cannot use the minimum and maximum functions in a BEFORE UPDATE trigger.
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.