Examine this code:
CREATE OR REPLACE PROCEDURE load_bfile
(p_file_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_file_loc, V_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

Question

Examine this code:
CREATE OR REPLACE PROCEDURE load_bfile
(p_file_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_file_loc, V_filename);
 END LOOP;
END;
/
What does the BFILENAME function do?

Accepted Answer

C. C. It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system.

Answer

A. A. It reads data from an external BFILE.

Answer

B. B. It checks for the existence of an external BFILE.

Answer

D. D. It creates a directory object for use with the external BFILEs.

1Z0-147 Question #38: Real Exam Question with Answer & Explanation

Question

Options

Community Discussion