Free 1Z0-144 Web TestEngine Demo

Q5 Single choice

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?

A
The trigger is fired, a message is displayed, and the update is successful.
B
The trigger is fired and a message is displayed, but the update is rolled back.
C
The trigger is not fired because the WHEN clause should be used to specify the condition; however,
the update is successful.
D
The trigger is not fired because column names must be specified with the UPDATE event to identify
which columns must be changed to cause the trigger to fire; however, the update is successful.

1Z0-144 Web TestEngine demo