examine the following code create or replace trigger updsalary for each row..., Oracle PL/Sql 10g, Databases

Test
- Model Test
Index

Question:Examine the following code:
CREATE OR REPLACE TRIGGER UPD_SALARY
FOR EACH ROW
BEGIN
UPDATE TEAM
SET SALARY=SALARY+:NEW.SALARY
WHERE ID=:NEW.TEAM_ID
END;
Which statement must be added to make this trigger executable after updating the SALARY column of the PLAYER table?

A AFTER UPDATE ON PLAYER 
B AFTER SALARY UPDATE OF PLAYER 
C AFTER UPDATE(SALARY) ON PLAYER 
D AFTER UPDATE OF SALARY ON PLAYER

/50

+ AnswerA

+ Report

Descriptive on Oracle PL/Sql 10g Ebook

Total Preview: 709

Question:Examine the following code: CREATE OR REPLACE TRIGGER UPD_SALARY FOR EACH ROW BEGIN UPDATE TEAM SET SALARY=SALARY+:NEW.SALARY WHERE ID=:NEW.TEAM_ID END; Which statement must be added to make this trigger executable after updating the SALARY column of the PLAYER table?

A AFTER UPDATE ON PLAYER

B AFTER SALARY UPDATE OF PLAYER

C AFTER UPDATE(SALARY) ON PLAYER

D AFTER UPDATE OF SALARY ON PLAYER

A