oracle9i program with pl/sql

1.What can you do with the DBMS_LOB package?

A.Use the DBMS_LOB.WRITE procedure to write data to a BFILE.

B.Use the DBMS_LOB.BFILENAME function to locate an external BFILE.

C.Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.

D.Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed.

Correct:D

2.Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER, V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID, V_LAST_NAME); COMMIT; END; This procedure must invoke the UPD_BAT_STAT procedure and pass a parameter. Which statement, when added to the above procedure, will successfully invoke the UPD_BAT_STAT procedure?

A.EXECUTE UPD_BAT_STAT(V_ID);

B.UPD_BAT_STAT(V_ID);

C.RUN UPD_BAT_STAT(V_ID);

D.START UPD_BAT_STAT(V_ID);

Correct:B
oracle9i program with pl/sql, is a Oracle certification. It is very important for you to get IT certifications which can help you achieve your dreams.
With the study guides we provide for Oracle 1Z0-147, you can handle the hole exam points, and easily pass the exam without wasting much time on attending the expensive training class.We provide all kinds of exams for Oracle, if you want to know more about that, please enter our site. Oracle 1Z0-147 books.