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?

Question

Exhibits

Options

• AIt compiles successfully.
• BIt gives an error because the when condition is not valid.
• CIt gives an error because when cannot be used for row-level triggers.
• DIt gives an error because the statements under updating are not valid.
• EIt gives an error because the new qualifier in the when clause requires a colon prefix.

• A
  81% (13)
• C
  13% (2)
• D
  6% (1)

Explanation

TRIGGER max_credit_limit compiled.

No community discussion yet for this question.