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 user-defined type
A column in a table
A bind or host variable
A PL/SQL variable, parameter, or result
Internal 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
We absolutely love your blog and find almost all of your post’s to be just what I’m looking for. can you offer guest writers to write content for you? I wouldn’t mind creating a post or elaborating on many of the subjects you write with regards to here. Again, awesome web site!|
I’m not sure why but this weblog is loading extremely slow for me. Is anyone else having this problem or is it a issue on my end? I’ll check back later and see if the problem still exists.|