複選題
QUESTION 96 Which two statements about object dependencies are accurate? (Choose two.) 中間長度 BD
(A) When referencing a package procedure or function from a stand-alone procedure or function, if the package specification changes, the package body remains valid but the stand-alone procedure becomes invalid
(B) When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct remains valid.
(C) When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct becomes invalid
(D) When referencing a package procedure or function from a stand-alone procedure or function, If the package specification changes, the stand-alone procedure referencing a package construct as well as the package body become invalid

複選題QUESTION 92 Which two statements about functions are true? (Choose two.) 頭尾 (A) A function must have a return statement in its body to execute successfully (B) Client-side functions can be used in SOL statements (C) A stored function that is called from a SOL statement can return a value of any PL/SOL variable data type (D) From SOL*Plus, a function can be executed by giving the command EXECUTE functionname; (E) A stored function increases efficiency of queries by performing functions on the server rather than in the application

QUESTION 93 Examine this code CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2) IS V_file BFILE; v_filename VARCHAR2(16); CURSOR emp_cursor IS SELECT employee_id FROM employees WHERE Job_id = 'IT_PROG' FROM UPDATE BEGIN FOR emp_record IN emp_cursor LOOP v_filename:=emp_record.emplyee_id||;GIF'; V_file:=BFILENMAE(p_file_loc,v_filename); END LOOP; END; / What does the BFILENAME function do? LONG (A) It reads data from an external BFILE (B) It checks for the existence of an external BFILE (C) It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system (D) It creates a directory object for use with the external BFILEs

QUESTION 94 Consider this scenario A procedure X references a view Y that is based on a table Z . Which two statements are true? 1. Y is a referenced object 2. Z is a direct dependent of X 3. Y is a direct dependent of X 4. Y is an indirect dependent of X 5. Y is an indirect dependent of Z 6. Z is an indirect dependent of Y (A)13(B)24(C)35(D)16

QUESTION 95 Examine this code CREATE OR REPLACE FUNCTION change_dept (p_old_id NUMBER, p_deptname VARCHAR2) RETURN NUMBER IS v_new_id NUMBER BEGIN SELECT departments_seq.nextval INTO v_new_id FROM dual; UPDATE departments SET departmenet_id = v_new_id, Department_name = p_deptname WHERE department_id=p_old_id; Return v_new_id; End; / There are no foreign key integrity constraints on the EMPLOYEES and DEPARTMENTS tables. Which statement performs a successful update to the EMPLOYEES table? (A) UPDATE departments SET department_id = change_dept(10, 'Finance') Where dapartment_id=10; (B) UPDATE employees SET department_id = change_dept(10, 'Finance') Where dapartment_id=10; (C) UPDATE departments change_dept(270, 'Outsource') Where dapartment_name='payroll'; (D) UPDATE employees SET department_id = change_dept(10, 'Finance') WHERE department_id = DEPARTMENTS:CURRVAl;

複選題QUESTION 97 You need to create a trigger to ensure that information in the EMP table is only modified during business hours, Monday to Friday from 9:00am to 500pm Which types of trigger do you create? (Choose two.) (A) row level AFTER INSERT OR UPDATE OR DELETE ON EMP (B) row level BEFORE INSERT OR UPDATE OR DELETE ON EMP (C) statement level AFTER INSERT OR UPDATE OR DELETE ON EMP (D) statement level BEFORE INSERT OR UPDATE OR DELETE ON EMP

QUESTION 98 Examine this package: CREATE OR REPLACE PACKAGE BB_PACK IS V_MAX_TEM_SALARY NUMBER(12,2); PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VACHAR 2,V_SALARY NUMBER); END BB_PACk; / CREATE OR REPLACE PACKAGE BODY BB_PACK IS V_PLAYER_AVG NUMBER84,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 VARCHAR2, V_SALARY NUMBERI) 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; If you add an IF statement to the ADD_PLAYER procedure which additional step must you perform? r A Recompile the ADD PLAYER procedure Recompile both the BB PACK specification and body S~ (A) Recompile the ADD_PLAYER procedure (B) Recompile both the BB_PACK specification and body (C) Recompile the BB_PACK specification (D) Recompile the BB_PACK body

QUESTION 99 Which statement is true about removing packages? (A) You must remove the package body first (B) Removing a package specification removes the body too (C) Removing the package body removes the specification too (D) You must remove both the package body and the specification separately (E) Removing a package specification removes all stand alone stored functions named in the specification

複選題QUESTION 100 Which two statements are true about LOBs? (Choose two.) CE (A) BFILES are stored in the database (B) All LOBs have read and write access (C) NCLOB represents a multi-byte character object (D) The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types (E) The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types

QUESTION 101 You want to create procedures, functions and packages Which privilege do you need? (A) EXECUTE CODE object privilege (B) CREATE ANY CODE object privilege (C) CREATE PACKAGE system privilege (D) CREATE PROCEDURE system privilege (E) CREATE FUNCTION, CREATE PROCEDURE, CREATE PACKAGE system privileges

QUESTION 102 Examine this function: CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus? long (A) SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT; (B) EXECUTE CALC_PLAYER_AVG(31); (C) CALC_PLAYER('RUTH'); (D) CALC_PLAYER_AVG(31); (E) START CALC_PLAYER_AVG(31)