Flash back all the tables in the data file, one by one.
Restore the data file to a new location and perform a media recovery.
Flash back the database, there is no need to restore the data file.
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?()
第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?()
第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?()
第4题:
open the database with the RESETLOGS option
open the database with the RESTRICTED option
recover all the data files to the same system change number (SCN)
recover to the required SCN only that data file in which the error occurred
第5题:
flash back the corrupted blocks
use the DBMS_REPAIR package
use the RMAN TSPITR command
use the RMAN BLOCKRECOVER command
use the RESTORE DATABASE and RECOVER DATABASE commands
investigate the time at which the corruption occurred and perform a pointintime recovery
第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?()
第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?()
第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?()
第9题:
until the last commit
cannot be recovered
until the last offline backup
until the beginning of the last transaction
第10题:
Use the database link.
Use the SQL*Loader utility.
Use the Oracle Data Pump utility.
Create an external table and leave the data in the flat file