Multiple choice technology databases

Which datatype stores data outside Oracle Database?

  1. UROWID

  2. BLOB

  3. NCLOB

  4. BFILE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

BFILE is a unique Oracle datatype that stores a file pointer to data located outside the database in the operating system filesystem. Unlike BLOB and CLOB types which store data within the database, BFILE only maintains a reference to external files. UROWID is for rowids, NCLOB stores character large objects within the database.

Keep practicing — related questions