Oracle
1Z0-147 · Question #3
1Z0-147 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
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
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.