Which statements are true regarding SecureFile LOBs? (Choose all that apply.)
A.
The amount of undo retained is user controlled.
B.
SecureFile LOBs can be used only for nonpartitioned tables.
C.
Fragmentation is minimized by using variable-sized chunks dynamically.
D.
SecureFile encryption allows for random reads and writes of the encrypted data.
E.
It automatically detects duplicate LOB data and conserves space by storing only one
copy.
Explanation:
One of the new feature of Oracle 11g is that Oracle SecureFiles use variable chunk sizes,
which can be as large as 64 MB.By storing these chunks next to one another, Oracle also
minimizes fragmentation.
About Deduplication
SecureFiles Intelligent Deduplication, available with the Oracle Advanced Compression
Option, enables Oracle Database to automatically detect duplicate LOB data within a LOB
column or partition, and conserve space by storing only one copy of the data.
Note that you must have a license for the Oracle Advanced Compression Option before
implementing SecureFiles Intelligent Deduplication. See Oracle Database Licensing
Information for more information.
Note also that Oracle Streams does not support SecureFiles LOBs that are deduplicated.
About Encryption
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.