試題詳解

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