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’
FOR UPDATE;
BEGIN
FOR emp_record IN emp_cursor LOOP
V_filename:= emp_record.employee_id || ‘.GIF’;
V_file := BFILENAME(p_flle_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
Explanation:
In Oracle/PLSQL, the BFILENAME function returns a BFILE locator for a physical LOB binary file.
Incorrect Answers:
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 <directory name> AS <operating system path>;