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…
Sign in or unlock 1Z0-144 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-144 to see the answer
You've previewed enough free 1Z0-144 questions. Unlock 1Z0-144 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.
Topics
#PL/SQL triggers#NEW qualifier#row-level trigger#trigger compilation