Oracle
1Z0-147 · Question #27
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…
The correct answer is C. The trigger fails because a SELECT statement on the table being updated is not allowed. See the full explanation below for the reasoning.
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.
How the community answered
(37 responses)- A3% (1)
- B5% (2)
- C81% (30)
- D11% (4)
Community Discussion
No community discussion yet for this question.