Emplyeeidgif vfilebfilenmaepfilelocvfilename end

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: T 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? 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 Answer: C Explanation: In Oracle/PLSQL, the BFILENAME function returns a BFILE locator for a physical LOB binary file. Incorrect Answers Actualtests.com - The Power of Knowing 1Z0-147 A. DBMS_LOB.READ Procedure reads data from a BFILE. B. DBMS_LOB.FILEEXISTS functions checks for the existence of the file on the Server. D. You do not use the BFILENAME function to create a directory object. The syntax to create the directory object is: CREATE DIRECTORY AS ; QUESTION 104: Consider this scenario A procedure X references a view Y that is based on a table Z . Which two statements are true? (Choose two.) A. Y is a referenced object B. Z is a direct dependent of X C. Y is a direct dependent of X D. Y is an indirect dependent of X E. Y is an indirect dependent of Z F. Z is an indirect dependent of Y Answer: A, C Explanation: A. Y is referenced by X. C. There is a direct dependency between Z and X. Incorrect Answers B. X is an indirect dependent of X D. Y is a Direct dependent of X. E. Y is a direct dependent of Z. F. Z is a direct dependent of Y. QUESTION 105: 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 Actualtests.com - The Power of Knowing 1Z0-147 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 up...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online