What is the outcome when the above trigger is compiled?

View the Exhibit and examine the structure of the customer table.

Examine the following trigger code:

What is the outcome when the above trigger is compiled?

View the Exhibit and examine the structure of the customer table.

Examine the following trigger code:

What is the outcome when the above trigger is compiled?

A.
It compiles successfully.

B.
It gives an error because the when condition is not valid.

C.
It gives an error because when cannot be used for row-level triggers.

D.
It gives an error because the statements under updating are not valid.

E.
It gives an error because the new qualifier in the when clause requires a colon prefix.



Leave a Reply 2

Your email address will not be published. Required fields are marked *