单选题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？（）Aflash back all the tables in the data file， one by oneBrestore the data file to a new location and perform a media recoveryCflash back the database; there is no need to restore the data fileDrestore the data file from the most recent backup and flash back the database
单选题
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
参考解析
解析：
暂无解析
相关考题：
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 oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
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 blocksB、 use the DBMS_REPAIR packageC、 use the RMAN TSPITR commandD、 use the RMAN BLOCKRECOVER commandE、 use the RESTORE DATABASE and RECOVER DATABASE commandsF、 investigate the time at which the corruption occurred and perform a point-in-time recovery
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 commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.
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 databaseC、There is a readonly tablespace in your database.D、These are the data files that cannot be recovered.
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.
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 databaseC、 There is a read-only tablespace in your database.D、 These are the data files that cannot be recovered.
单选题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？（）Aflash back the corrupted blocksBuse the DBMS_REPAIR packageCuse the RMAN TSPITR commandDuse the RMAN BLOCKRECOVER commandEuse the RESTORE DATABASE and RECOVER DATABASE commandsFinvestigate the time at which the corruption occurred and perform a pointintime recovery
多选题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？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
单选题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（）AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate an external table and leave the data in the flat file
单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A2，4，3B1，4，3，2C2，5，4，3，6D5，2，4，3，6E1，5，4，3，6，2
单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）Arecover using Oracle Flashback Database technologyBrestore the data files from backup and perform a complete recoveryCrestore only the corrupted data file and perform tablespace recoveryDrestore the data files from backup and perform cancelbased recoveryErestore the entire database from the most recent backup and start the instance and open the database
单选题You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）AUse the database link.BUse the SQL*Loader utility.CUse the Oracle Data Pump utility.DCreate an external table and leave the data in the flat file
单选题Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
单选题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.
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）ARestore the data file for the SYSTEM tablespace then open the database. BRestore all redo logs form last night's backup, then restart the database. CPerform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. DMount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
单选题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？（）AThese are the data files that are corrupted.BThere is no SYSAUX tablespace in your databaseCThere is a readonly tablespace in your database.DThese are the data files that cannot be recovered.
单选题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）A datafileB alert logC dynamic viewsD control file script
多选题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？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
单选题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？（）AUntil last commitBUntil the time you perform recoveryCUntil the time the date file got corruptedDUntil the point where the last transaction begunEYou cannot recover the SYSTEMtablespaceand must re-create the database.
单选题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A2, 4, 3B1, 4, 3, 2C2, 5, 4, 3, 6D5, 2, 4, 3, 6E1, 5, 4, 3, 6, 2
单选题You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）AUpgrade the hardware/memory to accommodate the data.BLoad the data into your database by using the PARALLEL clause.CGive analysts DBA privilege， so that they can query DBA_EXTERNAL_TABLES.DUse an external table so you can have the metadata available in your database， but leave the data in the operating system files.
多选题In which of the scenarios will the DBA perform recovery（）AThe alert log file is corrupted.BA tablespace is accidentally dropped.COne of the redo log members is corrupted.DA database user terminates the session abnormally.EThe hard disk on which the data file is stored is corrupted.
单选题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 databaseC There is a read-only tablespace in your database.D These are the data files that cannot be recovered.
单选题You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）ARestore all the data files and open the databaseBCreate the data file and performtablespacerecoveryCNo need to restore any file， just recover the databaseDRestore only the system data file and recover the databaseERestore only lost date file and performtablespacerecovery