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?
View The Exhibi 1 (161.2 KiB) Viewed 129 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!