Which of the following trigger is executed once for each row in a transaction?

Related MCQs

• The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTERINSERT trigger.
• Which of the following trigger will be executed before modifying each row affected by the triggering statement?
• Which of the following is the default trigger that is created using the CREATE TRIGGER command?
• What is the name of a trigger that initiates another trigger?
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?
• The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
• The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
• The                      requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.
• An operation is said to be                      if executing it several times in a row gives the same result as executing it once.