Which two statements are true about BFILES? (Choose two.)
A.
BFILES support only sequential reads.
B.
BFILES can be used as attributes in an object type.
C.
When LOB is deleted, the corresponding physical file is automatically deleted.
D.
The RMAN backup automatically backs up the BFILE locators and the corresponding physical
files.
E.
The physical file corresponding to a BFILE locator must reside on the file system that is
accessible from the server where the database exists.
B,E
docs.oracle.com/database/121/JJDBC/oralob.htm#JJDBC28549
http://docs.oracle.com/cd/B10501_01/appdev.920/a96591/adl12bfl.htm#68330
http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT513
LOB datatypes (except NCLOB) can be attributes of a user-defined object type but LONG datatypes cannot.
NCLOB cannot be the attribute of user-defined object because NCLOB relies on the session specific parameter Nation Character.
Question: why long cannot be the attribute of user defined object?
D E
B E
CREATE OR REPLACE TYPE PIPPOTYPE AS OBJECT
( ID NUMBER,
BF BFILE);
DESCRIBE PIPPOTYPE
DROP TYPE MCDONALD.PIPPOTYPE;
CREATE OR REPLACE TYPE MCDONALD.PIPPOTYPE AS OBJECT
( ID NUMBER,
BF BFILE);