网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）
A
Database datafiles
B
Online redo logs
C
Archived redo logs
D
Backup control file
E
Control file from a backup
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which files are required for a full recovery of the database in ARCHIVELOG mode？（）ADatabase datafilesBOnline redo logsCArchived redo logsDBackup control fileEControl file from a backup” 相关考题
考题
Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.)
A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.
考题
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two)
A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log files required to perform recoveryE. Newly created tablespace which is not backed up
考题
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、usermanaged backups placed in the flash recovery areaE、usermanaged backups that have been cataloged with RMANF、usermanaged data file backups for which the full path name is specified
考题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A、 Database Identifier （DBID）B、 names and location of datafilesC、 names and location of control filesD、 names and location of online redo log files
考题
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 Control filesB、 Password filesC、 Inactive online redo log fileD、 Archived log files required to perform recoveryE、 Newly created tablespace which is not backed up
考题
If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（） A、 Complete database recovery.B、 Incomplete database recovery.C、 Approximate database recovery.D、 Archived database recovery.E、 The database could not be recovered with RMAN.
考题
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
考题
Which two are characteristics of user-managed backup and recovery operations？（）A、Recovery is initiated using SQL*Plus.B、Database files are backed up using SQL commands.C、Database files are backed up with Recovery Manager.D、Database files are restored using Recovery Manager.E、Database files are backed up using operating system commands.
考题
Identify two situations in which you can use Data Recovery Advisor for recovery.（） A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.
考题
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）A、 Database datafilesB、 Online redo logsC、 Archived redo logsD、 Backup control fileE、 Control file from a backup
考题
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
考题
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 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 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
考题
多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
考题
多选题You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）AFlashback log filesBBackups that have become obsoleteCUser managed backups of the data files and control filesDArchived redo log files that have multiple copies in a different archive location and not backed up
考题
多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up
考题
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction.
考题
多选题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 are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
单选题You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process？（）A
Database Identifier （DBID）B
names and location of datafilesC
names and location of control filesD
names and location of online redo log files
考题
多选题Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
考题
多选题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）
考题
多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDusermanaged backups placed in the flash recovery areaEusermanaged backups that have been cataloged with RMANFusermanaged data file backups for which the full path name is specified
考题
多选题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
考题
单选题If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）A
Complete database recovery.B
Incomplete database recovery.C
Approximate database recovery.D
Archived database recovery.E
The database could not be recovered with RMAN.
热门标签
最新试卷