Oracle OCP 1Z0-050（36题）解析

最新推荐文章于 2021-07-24 13:29:39 发布

梅森上校

最新推荐文章于 2021-07-24 13:29:39 发布

阅读量220

点赞数

分类专栏： Oracle开发与管理 Oracle OCP解析文章标签： Oracle Oracle 11g OCP 1Z0-050

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/seagal890/article/details/82908680

版权

101 篇文章 2 订阅

订阅专栏

39 篇文章 0 订阅

订阅专栏

Oracle OCP 1Z0-050（36题）解析

QUESTION 36:

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. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

B. The LOB values are cached by default in the buffer cache.

C. The LOB values are automatically stored in encrypted mode.

D. The LOB values are automatically compressed.

Answer: A

解析：

Oracle SecureFiles adds the following capabilities:

Intelligent LOB compression enables users to explicitly compress data to save disk space. This feature can only be used with the new LOB implementation in this release (storage parameter SECUREFILE).
Intelligent LOB encryption introduces a new encryption facility for LOBs. The encrypted data in now stored in-place and is available for random reads and writes. This feature can only be used with the new LOB implementation in this release (storage parameter SECUREFILE).
Deduplication enables Oracle Database to automatically detect duplicate LOB data and conserve space by only storing one copy (storage parameter SECUREFILE).
LOB data path optimization includes logical cache above storage layer, read prefetching, new caching modes, vectored IO, and so on.
New LOB APIs. Existing OCI functions work on the new SECUREFILE LOBs. New OCI functions and PL/SQL packages are also added. Parameters of the CREATE TABLE, ALTER TABLE, and SQL commands are new or changed for LOBs. High performance space management includes changes to LOB SQL statements and DBMS_SPACE package changes.

关注