Oracle
1Z0-144 · Question #34
View the Exhibit and examine the structure of the customer table. You need to create a trigger to ensure that customers in category "A" and "B" have a credit limit of more than 8000. Examine the…
The correct answer is D. It gives an error on compilation because the new qualifier can be used only in row-level triggers. NEW and OLD can be used only in row level triggers.
Configuring JDBC Data Sources
Question
View the Exhibit and examine the structure of the customer table. You need to create a trigger to ensure that customers in category "A" and "B" have a credit limit of more than 8000. Examine the following trigger. Which statement is correct about the outcome of this trigger?
Exhibit
Options
- AIt compiles successfully and fires whenever the specified condition is met.
- BIt compiles successfully but does not fire even when the condition is met
- CIt gives an error on compilation because the new qualifier is prefixed with a colon.
- DIt gives an error on compilation because the new qualifier can be used only in row-level triggers.
How the community answered
(52 responses)- A8% (4)
- B4% (2)
- C13% (7)
- D75% (39)
Explanation
NEW and OLD can be used only in row level triggers.
Topics
#PL/SQL triggers#NEW qualifier#row-level trigger#trigger compilation
Community Discussion
No community discussion yet for this question.