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会共享相同的数据块
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博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2074191/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
