单选题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 thetablespac

第1题：

A corrupted file system is now repaired and back in use. Some， but not all of the files within the file  systems have been deleted. The only backup of this file system is a month-old tar archive. This archive will need to be restored as root.  Which two statements correctly describe the effects of the restore operation？（）

• A、 Files found in the file system that are also on tape will NOT be overwritten.
• B、 The missing files， present on the backup tape， are restored to the file system with the data as it was when the backup was taken.
• C、 The access times are preserved by tar and will reflect the time when a user last accessed the data.
• D、 The modification time on the files restored by tar will be preserved and will reflect the time the file was last modified before the backup， NOT the time of the restore operation.

第2题：

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.

第3题：

Which two statements correctly describe the relation between a data file and the logical databasestructures（）

• A、An extent cannot spread across data files.
• B、A segment cannot spread across data files.
• C、A data file can belong to only one tablespace.
• D、A data file can have only one segment created in it.
• E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

第4题：

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.

第5题：

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.

第6题：

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

第7题：

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.

第8题：

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（）

• 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

第9题：

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

第10题：

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

• A、 Restore the lost data file from the backup， and then flash back the database.
• B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
• C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
• D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
• E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.