Oracle 11G OCP 1Z0-053 203

(203)Which statement about the enabling of table compression in Oracle Database 11g is true?

A. Compression can be enabled at the table,tablespace,or partition level for direct loads only.

B. Compression can be enabled only at the table level for both direct loadsand conventional DML.

C. Compression can be enabled at the table,tablespace,or partition level for conventional DML only.

D. Compression can be enabled at the table,tablespace,or partition level for both direct loads and conventional DML.

答案:(D)

解析:

You can specify compression for a tablespace,a table,or a partition.If specified at the tablespace level,then all tables created in that tablespace are compressed by default.

Compression has a cost in CPU overhead for data loading and DML.

请使用浏览器的分享功能分享到微信等