A sys privileges b your privileges c public

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: under whose privilege the operations performed by default? A. Sys privileges. B. Your privileges. C. Public privileges. D. User A's privileges. E. User A can't execute your procedure that has dynamic SQL. Answer: B QUESTION 57: Examine the trigger heading CREATE OR REPLACE TRIGGER SALARY_CHECK Before update (sal,job) on emp For each row Actualtests.com - The Power of Knowing 1Z0-101 Under what conditions does this trigger fire? A. When a row is inserted to EMP table. B. When the value of the sal or job column in a row is updated in a emp table. C. When any column other than the sal or job columns in a row are updated in the EMP table. D. Only when both values of sal or jobs column in a row are updated together in the EMP table. Answer: B QUESTION 58: Which code can you use to ensure that the salary is neither increased by more than 10% at a time nor is ever decreased? A. ALTER TABLE emp ADD constraint_ck_sal CALC(sal BETWEEN sal AND sal*1.1); B. CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal ON emp FOR EACH ROW WHEN(NEW.SAL<OLD.SAL OR NEW.SAL>OLD.SAL*1.1) BEGIN RAISE_APPLICATION_ERROR(-20508, 'do not decrease salary nor increase by more than 10%'); END; C. CREATE OR REPLACE TRIGGER check_sal BEFORE UPDATE OF sal OR emp WHEN (NEW.SAL<OLD.SAL OR NEW.SAL>OLD.SAL*1.1) BEGIN RAISE_APPLICATION_ERROR(-20508, 'Do not decrease salary nor increase by more than 10%'); D. CREATE OR REPLACE TRIGGER check_sal AFTER UPDATE OF sal OR emp WHEN (NEW.SAL<OLD.SAL OR NEW.SAL>OLD.SAL*1.1) BEGIN RAISE_APPLICATION_ERROR(-20508, 'Do not decrease salary nor increase by more than 10%'); END; Answer: B Actualtests.com - The Power of Knowing 1Z0-101 QUESTION 59: Which command must you issue to allow users to access the UPD_TEAM_STAT trigger on the TEAM table? A. GRANT SELECT, INSERT, UPDATE, DELETE ON TEAM TO PUBLIC; B. GRANT SELECT, INSERT, UPDATE, DELETE ONUPD_TEAM_STAT TO PUBLIC; C. GRANT EXECUTE ON TEAM TO PUBLIC; D. GRANT SELECT, EXECUTE ON TEAM, UPD_TEAM_STAT TO PUBLIC; Answer: A QUESTION 60: Which compiler directive to check the purity level of functions? A. PRAGMA SECURITY_LEVEL. B. PRAGMA SEARIALLY_REUSABLE. C. PRAGMA RESTRICT_REFERRENCES. D. PRAGMA RESTRICT_PURITY_LEVEL. E. PRAGMA RESTRICT_FUNCTION_REFERRENCE. Answer: C QUESTION 61: You have an after update ROW-LEVEL TRIGGER on the table EMP. This trigger queries the EMP table and inserts the updating users information into the AUDIT_TABLE. What happens when the users update rows on the EMP table? A. A compile time error occurs. B. A run time error occurs. The effect of the trigger body and the triggering statement are rolled back. C. A run time error occurs. The effect of the trigger body is rolled back but the update on the EMP table takes place. D. The trigger file successfully update the EMP file on the EMP table occurs and the data is asserted into the AUDIT_TABLE. E. A run time error occurs. The update on the EMP table does not take place but the insert into the AUDIT_TABLE occurs. Answer: A Actualtests.com - The Power of Knowing 1Z0-101 QUESTION 62: 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 VARCHER2,V_SALARY NUMBER); END BB_PACK; / CREATE OR REPLACE PACKAGE BODY BB_PACK IS V_PLAYER_AVG NUMBER(4,3); 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; VALIDATE_PLAYER_STAT(V_ID); END UPD_PLAYER_STAT; PROCEDURE ADD_PLAYER; (V_ID IN NUMBER, V_LAST_NAME VARCHER2,V_SALARY NUMBER) IS BEGIN INSERT INTO PLAYER(ID, LAST_NAME,SALARY) VALUES (V_ID,V_LAST_NAME,V_SALARY); UPD_PLAYER_STAT(V_ID,0,0); END ADD_PLAYER; END BB_PACK; / Which statement will successfully assign .333 to the V_PLAYER_AVG variable from a procedure outside the package? A. V_PLAYER_AVG:=.333; B. BB_PACK.UPD_PLAYER_STAT.V_PLAYER_AVG:=.333; C. BB_PACK.V_PLAYER_AVG:=.333; D. This variable can't be assigned a value form outside of the package. Answer: D QUESTION 63: Actualtests.com - The Power of Knowing 1Z0-101 Which part of a database trigger determines the number of times the trigger body executes? A. Trigger type. B. Trigger body. C. Trigger event. D. Trigger timing. Answer: A QUESTION 64: DRAG DROPDrag the routines into the utilization orderwhen using dynamic SQL? Answer: QUESTION 65: Given the header of a procedure ACCOUNT_TRANSACTION:CREATE OR REPLACE PROCEDURE ACCOUNT_TRANSACTION IS BEGIN END Which command will execute the PROCEDURE ACCOUNT_TRANSACTION from the SQL Plus prompt? A. ACCOUNT_TRANSACTION; B. RUN ACCOUNT_TRANSACTION; C. START ACCOUNT_TRANSACTION; Actualtests.com - The Power of Knowing 1Z0-101 D. EXECUTE ACCOUNT_TRANSACTION; Answer: D QUESTION 66: CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEAM_SALARY NUMBER(12,2); PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHER2, V_SALARY_NUMBER); END BB_PACK / 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 PLAYER_ID=V_ID; COMMIT; END...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online