B the value of discountrate is set to 010 each time

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ns 0.00 in a session. B. The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session. C. The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked. D. The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session. Answer: D Actualtests.com - The Power of Knowing 1Z0-147 A one-time-only procedure is executed only once, when the package is first invoked within the user session QUESTION 22: Examine this code: CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON emp BEGIN INSERT INTO audit_table (who, dated) VALUES (USER, SYSDATE); END; You issue an UPDATE command in the EMP table that results in changing 10 rows. How many rows are inserted into the AUDIT_TABLE? A. 1 B. 10 C. None D. A value equal to the number of rows in the EMP table. Answer: A Explanation: Since the Trigger Type is not specified this Trigger defaults to a FOR EACH STATEMENT Trigger. FOR EACH STATEMENT fire once for the triggering event, therefore one record will be inserted into the audit_table. Incorrect Answers B. If this was a FOR EACH ROW Trigger 10 rows would be inserted into the audit_table. C. This trigger will fire & result in 1 record inserted into the audit_table D. If all records were updated and the Trigger was a FOR EACH ROW Level Trigger then this would be the correct Response QUESTION 23: Examine this package: CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEAM_SALARY NUMBER(12,2); PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY_NUMBER; END BB_PACK; / Actualtests.com - The Power of Knowing 1Z0-147 CREATE OR REPLACE PACKAGE BODY BB_PACK IS PROCEDURE UPD_PLAYER_STAT (V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB, HITS = HITS + V_HITS WHERE PLAYER_ID = V_ID) COMMIT; END UPD_PLAYER_STAT; PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER) IS BEGIN INSERT INTO PLAYER(ID,LAST_NAME,SALARY) VALUES (V_ID, V_LAST_NAME, V_SALARY); UP...
View Full Document

Ask a homework question - tutors are online