[Solved] The OLD and NEW qualifiers can be used in which type of trigger?

McqMate

Q.	The OLD and NEW qualifiers can be used in which type of trigger?
A.	Row level DML trigger
B.	Row level system trigger
C.	Statement level DML trigger
D.	Row level application trigger
Answer» A. Row level DML trigger

1.2k

0

Do you find this helpful?

2

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

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 is the default trigger that is created using the CREATE TRIGGER command?
What is the name of a trigger that initiates another trigger?
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?
Which of the following can initiate a trigger?
Which of the following command is used to delete a trigger?
Which of the following is NOT an Oracle- supported trigger?
Which of the following trigger is executed once for each row in a transaction?
Which of the following specifies a boolean expression that must be true for the trigger to fire?
Which of the following trigger will be executed before modifying each row affected by the triggering statement?