Question 10
View the Exhibit and examine the structure of the AUDIT_CUST table.
CUST_ID and CUST_CREDIT_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:
Which statement is true about the above trigger?
It gives an error on compilation because it should be a statement-level trigger.
It compiles and fires successfully when the credit limit is updated in the customer table.
It gives an error on compilation because of the commit command in the trigger code.
It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
Correct answer: D