Oracle
1Z0-144 · Question #26
View the Exhibit and examine the structure of the customer table. You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit…
The correct answer is A. The trigger is fired, a message is displayed, and the update is successful. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the customer table. You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000. What is the outcome?
Exhibits
Options
- AThe trigger is fired, a message is displayed, and the update is successful
- BThe trigger is fired and a message is displayed, but the update is rolled back.
- CThe trigger is not fired because the when clause should be used to specify the condition,
- DThe trigger is not fired because column names must be specified with the update event to identify
How the community answered
(33 responses)- A85% (28)
- B3% (1)
- C9% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.