多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs
多选题
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）
A
Database datafiles
B
Control files
C
Archived redo logs
D
Online redo logs
E
Flashback logs
参考解析
解析：
暂无解析
相关考题：
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two) A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.
Which of the following statements is NOT true about RMAN？（）A、It improves usability by enabling you to reuse the scripts to perform recovery operations.B、It detects block corruption while restoration and recovery operations.C、It enables you to perform block media recovery.D、It is capable to recover through unrecoverable operations， with only full database backups.
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance recovery.B、On startup， CKPT coordinates instance recovery.C、On startup， use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup， perform media recovery and then instance recovery.F、On startup， all the files will be synchronized and you get both committed and uncommitted data.
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
In which scenario will you perform an incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、 when all the control files are deletedC、 when a member of a multiplexed redo log group is droppedD、 when you are required to recover a table to its previous state
You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A、 incomplete recoveryB、 complete recoveryC、 recovery using the Flashback Database featureD、 recovery using the export/import utility
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number （SCN）.
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do？（）A、Create a System Restore point.B、Perform an Automated System Recovery （ASR） backup and restore.C、In the Backup and Restore Center window， click the Back up files button.D、In the Backup and Restore Center window， click the Back up computer button.
单选题You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）A incomplete recoveryB complete recoveryC recovery using the Flashback Database featureD recovery using the export/import utility
单选题Which of the following statements is NOT true about RMAN？（）AIt improves usability by enabling you to reuse the scripts to perform recovery operations.BIt detects block corruption while restoration and recovery operations.CIt enables you to perform block media recovery.DIt is capable to recover through unrecoverable operations， with only full database backups.
多选题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
单选题You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A take data files from the read-only tablespace offline before performing a recoveryB recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC drop the read-only tablespace and re-create the tablespace after recoveryD perform a recovery； status of the tablespace in control file will be changed automatically
单选题Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.CRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.DRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number （SCN）.
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
多选题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）
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）ASMON would automatically restore the lost file.BYou would need to restore the whole database from the last backup.CYou would need to restore the file from the last full database backup.DYou would need to use flashback technology to restore the lost redo log member.EYou would need to use Recovery Manager （RMAN） to restore the lost redo log member.FYou would need to restore the missing log file by copying one of the remaining files from the same group.
多选题You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery
单选题In which scenario will you perform an incomplete recovery？（）A when a table is dropped and stored in the Recycle BinB when all the control files are deletedC when a member of a multiplexed redo log group is droppedD when you are required to recover a table to its previous state
多选题Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）ADatabase datafilesBControl filesCArchived redo logsDOnline redo logsEFlashback logs