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.
答案：（D）
解析：
D，说它们共享同一个块，也就是重复的值只存一份，也就是压缩去重操作。