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.
B,C
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABJFIBC
B,D
…. ABOUT D : http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams063.htm
ALWAYS attempts to create all LOBs as SECUREFILE LOBs but creates any LOBs not in ASSM tablespaces as BASICFILE LOBs, unless SECUREFILE is explicitly specified.
Answer “D” is wrong, because it says about “LOBs that are stored in locally managed tablespaces”
…. ABOUT D : http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams063.htm
may be question meant use of
DBMS_LOB.SETOPTIONS
This procedure sets features. It enables the features to be set on a per-LOB basis, overriding the default LOB settings. This call incurs a round trip to the server to make the changes persistent.
????????
. ALWAYS: Apart from normal SecureFiles, all BasicFiles on ASSM tablespaces
are also treated as SecureFiles. But BasicFiles, which are created on a
non-ASSM tablespace, are still BasicFiles.
• FORCE: All LOB columns (both with SecureFile and BasicFile specifications)
are forced to be created as SecureFiles only. It does not allow any LOB
column to be created on a non-ASSM tablespace.
B, C
B.
Storage of SecureFiles
A SecureFile can only be created in an automatic segment space management (ASSM) tablespace.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#i1006363
C.
PL/SQL Packages for SecureFiles: Column Settings
DBMS_LOB Package.
DBMS_LOB.SETOPTIONS
This procedure sets features. It enables the features to be set on a per-LOB basis, overriding the default LOB settings.
This call incurs a round trip to the server to make the changes persistent.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#BABGEJDE