Which two statements are true regarding SecureFile lobs?
A.
The amount of undo retained is user controlled.
B.
They can be used only for nonpartitioned tables.
C.
Fragmentation is minimized by using variable-sized chunks.
D.
They support random reads and writes of encrypted LOB data.
Explanation:
Reference:
http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46113
C and D?
C and D
https://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46110
Thanks Vonpire!
D is here, C i find no reference. 🙁
SecureFiles Intelligent Encryption, available with the Oracle Advanced Security Option, introduces a new encryption facility for LOBs. The data is encrypted using Transparent Data Encryption (TDE), which allows the data to be stored securely, and still allows for random read and write access.
B is wrong
Can I enable SecureFiles at the partition-level?
Yes, SecureFiles can be enabled only for new partitions while older partitions continue to use older LOBs or BasicFiles.
http://www.oracle.com/technetwork/database/sf-faq-082597.html#A130
CD
CD
http://www.oracle.com/technetwork/jp/content/20100204-lob-255449-ja.pdf
CD
C is here
http://www.oracle.com/technetwork/database/features/secure-files/securefiles-whitepaper-2009-160970.pdf
SecureFiles, unlike BasicFiles or older LOBs, uses a dynamic CHUNK (one or more contiguous Oracle blocks) size setting to maximize contiguous allocations on disk and reduce fragmentation.
CD