Oracle
1Z0-144 · Question #39
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…
The correct answer is D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt gives an error on compilation because it should be a statement-level trigger.
- BIt compiles and fires successfully when the credit limit is updated in the customer table.
- CIt gives an error on compilation because of the commit command in the trigger code
- DIt compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER
How the community answered
(46 responses)- A2% (1)
- B4% (2)
- C9% (4)
- D85% (39)
Community Discussion
No community discussion yet for this question.
