Which statements are true about the SecureFile storage paradigm? (Choose two.)
A.
SecureFile storage can be used for internal and external LOBs.
B.
Automatic Segment Space Management must be enabled for a tablespace to store SecureFile LOBs
C.
SecureFile options enabled for a LOB column can be overridden on a per-LOB basis within the column.
D.
SecureFile is the default storage paradigm for all LOBs that are stored in locally managed tablespaces if the DB_SECUREFILE parameter is set to ALWAYS.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#CHDHDDDD
DBMS_LOB.SETOPTIONS: “This procedure enables/disables CSCE features on a per-LOB basis, overriding the default LOB column settings.”
Thanks Biga for the hyper link of DBMS_LOB.SETOPTIONS
Why A is wrong”
external lob(BFILE) could not be secure lob. the compression, deduplication, security can not apply to BFILE.
B C
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABGEJDE
D is true
https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams066.htm
DB_SECUREFILE specifies whether or not to treat LOB files as SecureFiles.
“ALWAYS
Attempts to create all LOBs as SecureFile LOBs but creates any LOBs not in an Automatic Segment Space Managed tablespace as BasicFile LOBs, unless SECUREFILE is explicitly specified. Any BasicFile LOB storage options that are specified will be ignored and the SecureFile defaults will be used for all storage options not specified.”
And
“DBMS_LOB.SETOPTIONS cannot be used to enable or disable encryption on individual LOBs.”
So my answer is B,D