Which two statements are true about LOBs? (Choose two.)
A.
BFILES are stored in the database
B.
All LOBs have read and write access
C.
NCLOB represents a multi-byte character object
D.
The Oracle9i server performs implicit conversions between BLOBs and NUMBER data types
E.
The Oracle9i server performs implicit conversions between CLOBs and VARCHAR2 data types
Explanation:
A: T he BFILE data type is an external LOB. External LOBs are stored outside the database in
operating system files.
B: BFILEs are read-only, and they cannot participate in transactions that occur within the
database.
D: You can perform Implicit conversions between LONG and CLOB columns and RAW and BLOB
columns but you can’t implicitly convert between BLOBS and NUMBER.