cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
第1题:
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()
第2题:
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
第3题:
It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()
第4题:
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()
第5题:
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()
第6题:
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
第7题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第8题:
cannot be used in RMAN
by starting up the database again
by using the CATALOG command of RMAN
by using the RECOVER CATALOG command in RMAN
by re-creating the target control file to rebuild the RMAN repository
第9题:
recovery cannot be performed because a backup was not performed after the last incomplete recovery
restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
第10题:
You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
第11题:
SQL script
PL/SQL script
Operating System (OS) script
Enterprise Manager (EM) script
Recovery Manager (RMAN) script
第12题:
target database
auxiliary database
third-party database
recovery catalog database
第13题:
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users?()
第14题:
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()
第15题:
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?()
第16题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第17题:
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()
第18题:
A backup of the target database when it is mounted
A backup of online redo log files when the database is open
A backup of only used data blocks in the file beingbeingbackup up
A backup of online, read/write data files when the database is open
A backup of only those data blocks that have changed since a previous backup
A backup of online, read/write data files when the database is in the NOMOUNT state.
第19题:
RMAN would use the current operating system location to place the backup.
RMAN would use the control file of the target database to maintain the backup.
RMAN would use the recovery catalog of the target database to maintain the backup.
RMAN would use the control file of the target database to maintain the backup metadata.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
第20题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第21题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第22题:
The backup status will be marked expired in RMAN recovery catalog.
The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery catalogl
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).
The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).
第23题:
You need to perform the restore and recover operations manually, because the backup was made manually.
First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database.
First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database.
You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.
第24题:
recovery cannot be performed because a backup was not performed after the last incomplete recovery
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday