移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table?()

发布日期:2021-09-22

The ADMIN_EMP table has columns EMPNO, ENAME, DEPT...
A

The materialized view should have a complete refresh performed after the online table redefinition is completed.

B

The materialized view should have a fast refresh performed after the online table redefinition is completed.

C

The materialized view,materialized log,and the index should be dropped and re-created after the online table redefinition is complete.

D

The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!