An application developer has written an AFTER STATEMENT trigger for UPDATE event on the ORDERS table of ORDER ENTRY application. The trigger saves the details of the user performing the update, system date, number of records updated to the AUDIT table. User, ERIC accesses ORDER ENTRY application and submits an UPDATE on ORDERS table through a batch job. However, the update statement affects ZERO records from ORDERS table. What is true in the context of the database trigger being written?

technology databases

  1. Database Trigger will NOT fire at all as number of records updated are ZERO. However, batch job will run through successfully.

  2. Database Trigger will fire only ONCE and will save details viz. "ERIC", "SYSDATE" and "0" to the AUDIT table. The batch job will run through successfully.

  3. Database Trigger will return an ERROR and abort the batch job

  4. Database Trigger will return an ERROR. However, batch job will run through successfully

Show answer
Correct Option: B

Find more quizzes: