單項選擇題

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.

你可能感興趣的試題

單項選擇題

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：
SQL>SELECT /+ RESULT_CACHE / sale_category， sum（sale_amt） FROM sales
GROUP BY sale_category；
Where would the result of this query be stored（）？

A. database buffer cache
B. shared pool
C. PGA
D. large pool

多項選擇題

Which two are the prerequisites to enable Flashback Data Archive？（）

A. Database must be running in archivelog mode.
B. Automatic undo management must be enabled.
C. Undo retention guarantee must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

你可能感興趣的試題

Which two are the prerequisites to enable Flashback Data Archive？（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Which two are the prerequisites to enable Flashback Data Archive？（）