You have an AFTER UPDATE row-level trigger on the table EMP. This trigger queries the EMP table and inserts the updating user's information into the AUDIT_TABLE . What happens when the user updates…

Question

Options

• AA compile time error occurs.
• BA runtime error occurs. The effect of trigger body and the triggering statement are rolled back.
• CA runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place.
• DThe trigger fires successfully. The update on the EMP table occurs, and data is inserted into the AUDIT_TABLE table.
• EA runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.

• A
  2% (1)
• B
  73% (33)
• C
  13% (6)
• D
  4% (2)
• E
  7% (3)

No community discussion yet for this question.