网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?() a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.
A
a, b, c, d, e, f
B
c, d, a, b, f
C
d, c, a, b, f
D
d, b, d, c, e
E
d, c, a, b, e
参考答案
参考解析
解析:
暂无解析
更多 “单选题When performing a full database disaster recovery with RMAN, in what order would you execute these steps?() a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A a, b, c, d, e, fB c, d, a, b, fC d, c, a, b, fD d, b, d, c, eE d, c, a, b, e” 相关考题
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()
A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period
考题
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database
考题
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
考题
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 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
考题
In which scenario will you perform a cancel-based recovery?()A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
考题
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?() A、 Issue the grant command from the SYS user (or equivalent) of the target database.B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
考题
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.
考题
You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.
考题
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?()A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command
考题
When performing a full database disaster recovery with RMAN, in what order would you execute these steps?() a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a, b, c, d, e, fB、 c, d, a, b, fC、 d, c, a, b, fD、 d, b, d, c, eE、 d, c, a, b, e
考题
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)A、Reregistering the target database in recovery catalogB、Transporting the new tablespaces to the recovery catalog databaseC、Syncronizing the recovery catalog with the target database control fileD、Performing a fresh backup of the target database to include the new data files in the catalog database
考题
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A、 RMAN would use the current operating system location to place the backup.B、 RMAN would use the control file of the target database to maintain the backup.C、 RMAN would use the recovery catalog of the target database to maintain the backup.D、 RMAN would use the control file of the target database to maintain the backup metadata.E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.
考题
You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery
考题
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
考题
Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()A、 You can use RMAN stored scriptsB、 Recovery is faster if data is stored in catalog in addition to the control fileC、 You can store backup information of all registered databases in one placeD、 Database backups are automatically deleted when they are older than the specified time period
考题
单选题In which scenario will you perform a cancel-based recovery?()A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
单选题You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A
user managed complete recoveryB
user managed incomplete recoveryC
RMAN-based complete recoveryD
RMAN-based incomplete recovery
考题
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()A
Issue the grant command from the SYS user (or equivalent) of the target database.B
Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C
Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D
Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E
Issue the grant command from RMAN when connected to the target database.
考题
单选题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
考题
单选题You are maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday. How will you recover the dropped table, SCOTT.EMPLOYEE?()A
by using the Flashback Table featureB
by using the Flashback Database featureC
by performing incomplete recovery using RMAN utilityD
by performing incomplete recovery using user-managed recovery
考题
单选题You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()A
Open the database in NORMAL modeB
Open the database in read-only modeC
Open the database in RESTRICTED modeD
Open the database with the RESETLOGS option
考题
单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A
RMAN would use the current operating system location to place the backup.B
RMAN would use the control file of the target database to maintain the backup.C
RMAN would use the recovery catalog of the target database to maintain the backup.D
RMAN would use the control file of the target database to maintain the backup metadata.E
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
考题
单选题When performing recover of a database in NOARCHIVELOG mode with RMAN, the target database must be in the () state to restore the control file.A
OPENB
IDLEC
MOUNTD
NOMOUNT
考题
单选题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.
考题
单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A
The target database must be in the MOUNT mode to ensure restoration of the datafiles.B
You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C
The control file must be recreated.D
The database must be opened with the RESETLOGS option.
考题
多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database
热门标签
最新试卷