ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 203

Oracle 11G OCP 1Z0-053 203

原创 Oracle 作者:LuiseDalian 时间:2014-09-03 17:48:28 0 删除 编辑
(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博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1263024/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6040893