Oracle
1Z0-147 · Question #38
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_PRO
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
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?
Options
- AA. It reads data from an external BFILE.
- BB. It checks for the existence of an external BFILE.
- CC. It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system.
- DD. It creates a directory object for use with the external BFILEs.
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.