可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The ADMIN_EMP table ha


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?()

  • 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.
参考答案
参考解析:
分类:1Z0-053题库
相关推荐

1、While reviewing the ha

While reviewing the hacmp.out after a node failure,an administrator realizes that the custom Event&...

2、The application tables&ensp

The application tables owned by the user TEST in a test database need to be exported ...

3、某压差计如图所示,已知HA=HB=1m,ΔH=0.5m

某压差计如图所示,已知HA=HB=1m,ΔH=0.5m。求:PA-PB。

4、The TRANS_SUMMARY table&ens

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction...

5、The ORDERS table in&en

The ORDERS table in the database of a company contains one million records. The table is&e...

6、What would the amps be at 240 volts wi

What would the amps be at 240 volts with an 8 ohm resistance?()A32~5 ampsB25 ampsC1~5 ampsD30 am