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.
BLOB
B.
CLOB
C.
LONG RAW
D.
BFILE
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?
Can someone explainme why the answer is BFILE?? Why not CFILE?
As Oracle says: “LOB datatypes can be stored inline (within a table), out-of-line (within a tablespace, using a LOB locator), or in an external file (BFILE datatypes).”
Source: http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm
In the question it said the data was on flat files.
Correct answer is D