InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
You Have An Update Statement On A Table. The Table Has Statement-level And Row-level Triggers. Suppose The Statement Updates N Number Of Rows. How Many Times Triggers Will Be Fired? |
|
Answer» The TRIGGERS will be FIRED N+1 number of times. Row LEVEL TRIGGER will be fired n number of times, once for each row-level trigger and the statement-level trigger will be fired once. The triggers will be fired N+1 number of times. Row level trigger will be fired n number of times, once for each row-level trigger and the statement-level trigger will be fired once. |
|