违法和不良信息举报 联系客服
免费注册 登录

A data file become corrupted in your database due to bad sec

题目
单选题
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
A

 Flash back all the tables in the data file， one by one.

B

 Restore the data file to a new location and perform a media recovery.

C

 Flash back the database， there is no need to restore the data file.

D

 Restore the data file from the most recent backup and flash the database.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

  • A、Until last commit
  • B、Until the time you perform recovery
  • C、Until the time the date file got corrupted
  • D、Until the point where the last transaction begun
  • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

正确答案:A

第2题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  • A、 Flash back all the tables in the data file， one by one.
  • B、 Restore the data file to a new location and perform a media recovery.
  • C、 Flash back the database， there is no need to restore the data file.
  • D、 Restore the data file from the most recent backup and flash the database.

正确答案:B

第3题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  • A、flash back all the tables in the data file， one by one
  • B、restore the data file to a new location and perform a media recovery
  • C、flash back the database; there is no need to restore the data file
  • D、restore the data file from the most recent backup and flash back the database

正确答案:B

第4题：

多选题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）
A

open the database with the RESETLOGS option

B

open the database with the RESTRICTED option

C

recover all the data files to the same system change number （SCN）

D

recover to the required SCN only that data file in which the error occurred


正确答案： A,C
解析： 暂无解析

第5题：

单选题
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA/x7f01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
A

flash back the corrupted blocks

B

use the DBMS_REPAIR package

C

use the RMAN TSPITR command

D

use the RMAN BLOCKRECOVER command

E

use the RESTORE DATABASE and RECOVER DATABASE commands

F

investigate the time at which the corruption occurred and perform a point­in­time recovery


正确答案： F
解析： 暂无解析

第6题：

The loss of the control file forced you to re/x7fcreate the control file. After re/x7fcreating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five/x7fdigit number starting with 0.  What could be the possible reason？（）

  • A、These are the data files that are corrupted.
  • B、There is no SYSAUX tablespace in your database
  • C、There is a read­only tablespace in your database.
  • D、These are the data files that cannot be recovered.

正确答案:C

第7题：

The loss of the control file forced you to re-create the control file. After re-creating it and opening the database， you find that some of the data files are named as MISSINGnnnnn， where nnnnn is a five-digit number starting with 0. What could be the possible reason？（）

  • A、 These are the data files that are corrupted.
  • B、 There is no SYSAUX tablespace in your database
  • C、 There is a read-only tablespace in your database.
  • D、 These are the data files that cannot be recovered.

正确答案:C

第8题：

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

  • A、 flash back the corrupted blocks
  • B、 use the DBMS_REPAIR package
  • C、 use the RMAN TSPITR command
  • D、 use the RMAN BLOCKRECOVER command
  • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
  • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

正确答案:D

第9题：

单选题
Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）
A

until the last commit

B

cannot be recovered

C

until the last offline backup

D

until the beginning of the last transaction


正确答案： C
解析： 暂无解析

第10题：

单选题
ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）
A

Use the database link.

B

Use the SQL*Loader utility.

C

Use the Oracle Data Pump utility.

D

Create an external table and leave the data in the flat file


正确答案： A
解析： 暂无解析

更多相关问题
相关内容