View the Exhibit and examine the structure of the AUDIR_CUST table.Exhibit Missing -CUST_ID and CUST_LIMIT are existing
Posted: Sun Jun 11, 2023 3:56 pm
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.
- View The Exhibi 1 (161.2 KiB) Viewed 156 times
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.