ITPub博客

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

Oracle 11G OCP 1Z0-053 145

原创 Oracle 作者:LuiseDalian 时间:2014-08-26 07:16:34 0 删除 编辑
(145)You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.

The SALES table has a materialized view,materialized log,indexes,referential integrity constraint,and triggers with the PRECEDES clause existing on it.

What action is required for dependent objects when you perform online table redefinition?

A. The dependent materialized view should have a complete refresh performed after the online table redefinition process.

B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.

C. Referential integrity constraints must be manually enabled after the online table redefinition process.

D. The materialized log should be dropped before the online table redefinition process.

答案:(A)

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

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

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6042351