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.