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.
Explanation:
Incorrect Answers:
A: DBMS_LOB.WRITE is used to write to Internal LOBs.The internal LOB is stored inside the
Oracle server. A BLOB, NCLOB, or CLOB can be one of the following: An attribute of a userdefined type A column in a table A bind or host variable A PL/SQL variable, parameter, or
resultInternal LOBs can take advantage of Oracle features such as: Concurrency mechanisms
Redo logging and recovery mechanisms Transactions with commit or rollbacks
B: BFILENAME is a built-in function that initializes a BFILE column to point to an external file. Use
the BFILENAME function as part of an INSERT statement to initialize a BFILE column by
associating it with a physical file in the server file system. You can use the UPDATE statement to
change the reference target of the BFILE. A BFILE can be initialized to NULL and updated later by
using the BFILENAME function.
C: DBMS_LOB.FILEEXISTS function to find if the file exits on the server
ะก.