1Z0-101 Develop PL/SQL Program Units
Note 1: 1Z0-101 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 1Z0-101 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Note 2: 1Z0-101 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 10.
Examine this trigger: CREATE OR REPLACE TRIGGER CHECK_TOT_SALARY AFTER INSERT OR UPDATE OF SALARY ON PLAYER FOR EACH ROW DECLARE V_TOT_SALS NUMBER(12, 2); BEGIN SELECT SUM(SALARY) INTO V_TOT_SAL FROM PLAYER WHER TEAM_ID=:NEW. SALARY; END; Why does this trigger fail when inserting a row into player table?
A. You can't read data from a table that is being affected by the same trigger.
B. You can't use the sum function with row triggers.
C. You can't use the sum function with statement triggers.
D. You can't reference:NEW with row triggers.
Display Answer
- Based on the latest 1Z0-101 exam objectives!
- Designed like actual 1Z0-101 exam questions!
- 100% Verified Realistic 1Z0-101 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 1Z0-101 Questions Included!
- Constantly Updated Guide to Reflect the Current 1Z0-101 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
Demark
Took my last CCNP test last Friday. EliteCertify tests really made the difference, I passed every one on the first ...
London, UK
First class site! Just passed 70-290 and achieved my MCSE & MCSA. ...
NY, USA
I wanted to take a few minutes to thank EliteCertify for passing 3 exams towards my MCSE. ...
Keyword
