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:
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 statement should be introduced in the trigger.
C, but I think it should also give error for the :OLD value, because you cannot use :OLD in an INSERT statement inside a row-level trigger, since the INSERT allows only the :NEW value
C, you can’t use tcl commands in a trigger
this will compile successful, but produce error at run time
Reference:
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:486421585357
“You cannot commit in a trigger (until Oracle8i release 8.1 with autonomous transactions — these will NOT commit the “parent” statement but only allow you to create a small subtransaction that is standalone and independently commited.”