Oracle 1Z0 053 Q287(lob securefile DEDUPLICATE)

287.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.
Answer: D

相同的LOB會共享相同的資料塊

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074191/，如需轉載，請註明出處，否則將追究法律責任。