Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A.
The LOB values are automatically compressed.
B.
The LOB values are cached by default in the buffer cache.
C.
The LOB values are automatically stored in encrypted mode.
D.
All LOB data that is identical in two or more rows in a LOB column share the same data
blocks.
Explanation:
DEDUPLICATE or KEEP_DUPLICATES (Link)
The option DEDUPLICATE enables you to specify that LOB data which is identical in two or
more rows in a LOB column should share the same data blocks. The database combines
LOBs with identical content into a single copy, reducing storage and simplifying storage
management. The opposite of this option is KEEP_DUPLICATES.