You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan
to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the
new column?
A.
CLOB
B.
BLOB
C.
BFILE
D.
LONG RAW
Which data types would you use for the new column?
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan
to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the
new column?
A BFILE is a data type used to store a locator (link) to an external binary file (file stored outside of the database). The maximum size for such file can be up to 4 GB (operating system specific). From an Oracle perspective, BFILEs are read-only and cannot be replicated to another system.
Why BFILE? i think CLOB is the best way you can store the employee details.