移动端

  • 题王微信公众号

    题王微信公众号

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

单选题

Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i?()

发布日期:2021-11-17

Users complain SQL statements using a particular i...
A

Rebuild the index using the online option.

B

Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.

C

Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.

D

Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

标签: "暂无标签"

题王网让考试变得更简单

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