View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing -
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:
//IMG//
Which statement is true about the above trigger?
- A.It gives an error on compilation because it should be a statement-level trigger.
- B.It compiles and fires successfully when the credit limit is updated in the customer table.
- C.It gives an error on compilation because of the commit command in the trigger code.
- D.It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION