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.