多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题