This preview shows page 1. Sign up to view the full content.
Unformatted text preview: T employee_id
WHERE Job_id = 'IT_PROG'
FOR emp_record IN emp_cursor LOOP
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
In Oracle/PLSQL, the BFILENAME function returns a BFILE locator for a physical
LOB binary file.
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
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
A. Y is referenced by X.
C. There is a direct dependency between Z and X.
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)
Actualtests.com - The Power of Knowing 1Z0-147
SET departmenet_id = v_new_id,
Department_name = p_deptname
There are no foreign key integrity constraints on the EMPLOYEES and
Which statement performs a successful up...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09