1Z0-052 · Question #23
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…
The correct answer is C. BFILE. The BFILE data type stores a locator pointing to an external file on the server OS file system, allowing a table column to reference flat files stored outside the database.
Question
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?
Options
- ACLOB
- BBLOB
- CBFILE
- DLONG RAW
How the community answered
(29 responses)- B7% (2)
- C90% (26)
- D3% (1)
Why each option
The BFILE data type stores a locator pointing to an external file on the server OS file system, allowing a table column to reference flat files stored outside the database.
CLOB stores large character data directly inside the database and has no facility for pointing to or referencing external OS files.
BLOB stores large binary data inline within the database itself, rather than acting as a pointer to an external file location.
BFILE stores a file locator that points to a large binary file residing outside the Oracle database on the OS file system - this is the correct mechanism for referencing external flat files from a relational table column, as the file content remains external while only the pointer is stored in the row.
LONG RAW is a deprecated data type for storing raw binary data internally in the database and cannot reference or access external flat files on the OS file system.
Concept tested: Oracle BFILE data type for external file access
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Data-Types.html
Topics
Community Discussion
No community discussion yet for this question.