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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1263024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1263024/