单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
Which of the following commands should be run to verify that file system ／data is not corrupted?() A.fsck /dtaB.fsck datavgC.lqueryvg datavgD.stat /data
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
Which of the following commands should be run to verify that file system /data is not corrupted?（）A、fsck /dtaB、fsck datavgC、lqueryvg datavgD、stat /data
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.
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.
When performing an incomplete recover of the whole database， which data files must you restore？ （）A、Only the damaged or lost data files.B、All of the data files of the database.C、Only the data files belonging to the SYSTEM tablespace.D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.
View this parameter setting in your database： DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’ You created a tablespace by using this command： CREATE TABLESPACE USERS； Which two statements are true about the USERS tablespace？（）A、The tablespace has two data files.B、An error is reported and tablespace creation fails.C、Data files are created with names generated by the instance.D、The tablespace can be extended without specifying the data file.E、Data files belonging to the USERS tablespace cannot be renamed.
You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking file
You issue the following statement： SQL SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE； You receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
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 having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）A、any control fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）Athe alert log file and the trace filesB the redo log filesC the control fileD the change tracking file
单选题Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?（）APlace CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDb.BPlace CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.CIssue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.DTake the USERDATA tablespace offline in ACCOUNTS_PDb.
单选题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
单选题Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）Aany control fileBany archive log fileCone of the redo log membersDloss of the initialization parameter fileEany data file belonging to the default permanent tablespac
单选题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 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.
单选题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
单选题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.
单选题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 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.
单选题While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A Block Media Recovery must be used with RMAN.B You must perform complete recovery of individual blocks.C You must have a full RMAN backup， not an incremental backup.D You must use the DBVERIFY utility before using the Block Media Recovery feature.
多选题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.