CHANGE
RESYNC
CATALOG
CROSSCHECK
第1题:
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()
第2题:
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?()
第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题:
Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system?()
第5题:
You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager(RMAN), you migrate the complete production database to use the ASM instance. Which statement is true?()
第6题:
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?()
第7题:
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
第8题:
online redo log files
alert log files
control file
datafiles associated with the SYSTEM tablespace
第9题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed
Using this command to create backups improves the performance of the backup process
第10题:
RMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMF
RMAN would relocate all the database files to an ASM disk group.
RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
第11题:
control file
all datafiles
password file
online redo log file
archive redo log file
server parameter file
only the SYSTEM datafile
第12题:
CHANGE
RESYNC
CATALOG
CROSSCHECK
第13题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?()
第14题:
You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the ASM instance. Which statement is true? ()
第15题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第16题:
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? ()
第17题:
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()
第18题:
when you change the name of a datafile
when you drop a table from the database
when you take an export of the database
when you back up the database using OS utilities
when you issue an ALTER SYSTEM SWITCH LOGFILE statement
when you issue a BACKUP command from inside the RMAN run block
第19题:
SYSDBA
SYSOPER
No system privileges are required for the RMAN user.
Only SYS user can connect and execute RMAN commands on a target database.
第20题:
A different procedure is required to restore a database from compressed backups
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
Using this command to create backups minimizes the bandwidth consumed.
Using this command to create backups improves the performance of the backup process
第21题:
CHANGE
RESYNC
CATALOG
CROSSCHECK
第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题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2