Multiple choice technology databases

You can commit inside a trigger

  1. Yes, there is a workaround, but not directly

  2. yes directly

  3. no

  4. I dont Know

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

You cannot execute a direct COMMIT statement inside a database trigger. However, you can commit changes by using a workaround like declaring the trigger as an autonomous transaction via PRAGMA AUTONOMOUS_TRANSACTION.