Time

Email Us

admin@resultjob.com

Database Management System Question

Database Management System Question With Answer & Solution
Que. - A file used to govern the initialization of the instance is known as
Que. - SGA stands for
Que. - 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?
Que. - The OLD and NEW qualifiers can be used in which type of trigger?
Que. - Trigger are not supported in
Que. - 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.
Que. - What are the after triggers ?
Que. - Which of the following is NOT an Oracle-supported trigger?
Que. - Which of the following is true concerning triggers?
Que. - Which prefixes are available to Oracle triggers?