QUESTION 90 -- 10g OCP 升级11g OCP 1Z0-053

QUESTION 90
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 materialized log should be dropped before 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 dependent materialized view should have a complete refresh performed after the online table
redefinition process.


Answer: D

Comment:

1,After redefining a table that has a materialized view log, the subsequent refresh of any dependent materialized view must be a complete refresh.

2,Dependent views, triggers, functions, procedures, and packages are invalidated. Oracle Database attempts to revalidate them when they are next accessed, but you may need to alter these objects with the new column name if revalidation fails.

3,When online redefinition completes, the referential constraint is automatically enabled. In addition, until the redefinition process is either completed or aborted, any trigger defined on the interim table does not execute.

 

referrence link:https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables007.htm#ADMIN01514

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值