Oracle
1Z0-147 · Question #3
This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS) VALUES (NEW.ID, 1997, 0,0)…
The correct answer is A. row. See the full explanation below for the reasoning.
Question
This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS) VALUES (NEW.ID, 1997, 0,0); END; To which type must you convert the trigger to correct the error?
Options
- Arow
- Bstatement
- CORACLE FORM trigger
- DBefore
How the community answered
(60 responses)- A75% (45)
- B3% (2)
- C7% (4)
- D15% (9)
Community Discussion
No community discussion yet for this question.