单选题The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）A The data file cannot be recovered.B The date file can be restored from theSYSTEMauto backup.C Take thetablespaceoffl
题目
The data file cannot be recovered.
The date file can be restored from theSYSTEMauto backup.
Take thetablespaceoffline，drop，kand re-create it.
Recovery Manager （RMAN） is used to recover the data file.
The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
相似考题
更多“单选题The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）A The data file cannot be recovered.B The date file can be restored from theSYSTEMauto backup.C Take thetablespaceoffl”相关问题
-
第1题：
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？（）
- 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题：
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？（）
- A、recover using Oracle Flashback Database technology
- B、restore the data files from backup and perform a complete recovery
- C、restore only the corrupted data file and perform tablespace recovery
- D、restore the data files from backup and perform cancel-based recovery
- E、restore the entire database from the most recent backup and start the instance and open the database
正确答案:E -
第3题：
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file（）
- A、Take the USERS tablespace offline and re-create the lost data file.
- B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
- C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
- D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
正确答案:C -
第4题：
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 -
第5题：
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？（）
- 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.
正确答案:C -
第6题：
单选题How can a directory be excluded from a mksysb backup（）APut an entry in the /etc/exclude.rootvg file.
BPut an entry in the /etc/mksysb.exclude file.
CRemove the directory’s entry from the mksysb /image.data file.
DRemove the directory’s entry from the /var/adm/ras/bosinst.data file.
正确答案： D解析： 暂无解析 -
第7题：
单选题You work as a database administrator for Supportcenter.cn. 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 database
BCreate the data file and perform tablespace recovery
CNo need to restore any file， just recover the database
DRestore only the system data file and recover the database
ERestore only lost date file and performtablespacerecovery
正确答案： A解析： 暂无解析 -
第8题：
单选题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 commit
BUntil the time you perform recovery
CUntil the time the date file got corrupted
DUntil the point where the last transaction begun
EYou cannot recover the SYSTEMtablespaceand must re-create the database.
正确答案： B解析： 暂无解析 -
第9题：
单选题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
正确答案： A解析： 暂无解析 -
第10题：
单选题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 one
Brestore the data file to a new location and perform a media recovery
Cflash back the database; there is no need to restore the data file
Drestore the data file from the most recent backup and flash back the database
正确答案： D解析： 暂无解析 -
第11题：
单选题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 commit
BUntil the time you perform recovery
CUntil the time the date file got corrupted
DUntil the point where the last transaction begun
EYou cannot recover the SYSTEMtablespaceand must re-create the database.
正确答案： E解析： 暂无解析 -
第12题：
单选题The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）AThe data file cannot be recovered.
BThe date file can be restored from the SYSTEM auto backup.
CTake thetablespaceoffline，drop，kand re-create it.
DRecovery Manager （RMAN） is used to recover the data file.
EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
正确答案： B解析： 暂无解析 -
第13题：
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？（）
- A、 2，4，3
- B、 1，4，3，2
- C、 2，5，4，3，6
- D、 5，2，4，3，6
- E、 1，5，4，3，6，2
正确答案:E -
第14题：
The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）
- A、The data file cannot be recovered.
- B、The date file can be restored from theSYSTEMauto backup.
- C、Take thetablespaceoffline，drop，kand re-create it.
- D、Recovery Manager （RMAN） is used to recover the data file.
- E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
正确答案:A -
第15题：
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？（）
- A、Restore all the data files and open the database
- B、Create the data file and performtablespacerecovery
- C、No need to restore any file， just recover the database
- D、Restore only the system data file and recover the database
- E、Restore only lost date file and performtablespacerecovery
正确答案:A -
第16题：
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）
- A、The data file cannot be recovered.
- B、The date file can be restored from the SYSTEM auto backup.
- C、Take thetablespaceoffline，drop，kand re-create it.
- D、Recovery Manager （RMAN） is used to recover the data file.
- E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
正确答案:A -
第17题：
You are the network administrator for You administer a Windows Server 2003 computer named TestKing2. contains a shared folder named TestKingProjects. You use the Backup utility once each day to back up the TestKingProjects folder. You discover that a database file in the TestKingProjects folder is corrupt. You confirm that the file corruption is not the result of a virus. You need to replace the corrupted file by using the latest backup. You do not know whether the file was corrupted before or after the latest backup was completed. You need to verify that the file in the backup can be opened successfully before you overwrite the existing file. What should you do?（）
- A、In the Backup utility, select the Verify data after backup option.
- B、Run the Ntbackup //TestKing2/TestKingProjects /v:yes command.
- C、Restore the file to a temporary folder. Verify that the database file contains the correct data. Copy the restored file to the TestKingProjects folder.
- D、Restore the file to a temporary folder. Use the Windiff utility to compare the file in the temporary folder to the file in the TestKingProjects folder. Copy the restored file to the TestKingProjects folder.
正确答案:C -
第18题：
单选题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 technology
Brestore the data files from backup and perform a complete recovery
Crestore only the corrupted data file and perform tablespace recovery
Drestore the data files from backup and perform cancelbased recovery
Erestore the entire database from the most recent backup and start the instance and open the database
正确答案： B解析： 暂无解析 -
第19题：
单选题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，3
B1，4，3，2
C2，5，4，3，6
D5，2，4，3，6
E1，5，4，3，6，2
正确答案： B解析： 暂无解析 -
第20题：
单选题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？（）AFlash back all the tables in the data file， one by one.
BRestore the data file to a new location and perform a media recovery.
CFlash back the database， there is no need to restore the data file.
DRestore the data file from the most recent backup and flash the database.
正确答案： A解析： 暂无解析 -
第21题：
单选题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？（）ARebuild the index using the online option.
BTake 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.
CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
DTake 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.
正确答案： C解析： 暂无解析 -
第22题：
单选题The data file belonging to theSYSTEMtablespaceis corrupted and no backup of the file is available. How do you recover the data file？（）AThe data file cannot be recovered.
BThe date file can be restored from theSYSTEMauto backup.
CTake thetablespaceoffline，drop，kand re-create it.
DRecovery Manager （RMAN） is used to recover the data file.
EThe ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.
正确答案： C解析： 暂无解析 -
第23题：
单选题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，3
B1，4，3，2
C2，5，4，3，6
D5，2，4，3，6
E1，5，4，3，6，2
正确答案： E解析： 暂无解析 -
第24题：
单选题You are the network administrator for You administer a Windows Server 2003 computer named TestKing2. contains a shared folder named TestKingProjects. You use the Backup utility once each day to back up the TestKingProjects folder. You discover that a database file in the TestKingProjects folder is corrupt. You confirm that the file corruption is not the result of a virus. You need to replace the corrupted file by using the latest backup. You do not know whether the file was corrupted before or after the latest backup was completed. You need to verify that the file in the backup can be opened successfully before you overwrite the existing file. What should you do?（）AIn the Backup utility, select the Verify data after backup option.
BRun the Ntbackup //TestKing2/TestKingProjects /v:yes command.
CRestore the file to a temporary folder. Verify that the database file contains the correct data. Copy the restored file to the TestKingProjects folder.
DRestore the file to a temporary folder. Use the Windiff utility to compare the file in the temporary folder to the file in the TestKingProjects folder. Copy the restored file to the TestKingProjects folder.
正确答案： B解析： 暂无解析