You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? （）A、After two days, a backup will be marked obsoleteB、After two days, a backup will be deleted from the mediaC、If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.D、If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

考题 Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

查看答案

考题 In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

查看答案

考题 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.

查看答案

考题 Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

查看答案

考题 Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）A、The RMAN backup fails because the TOOLS tablespace is read-onlyB、The RMAN skips the backup of the tablespace because backup optimization is enabledC、The RMAN makes backup because optimization can be enabled only for backups to diskD、The RMAN makes the backup because no backup of the tablespace exists within the seven day window

查看答案

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

查看答案

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

查看答案

考题 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？（）A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

查看答案

考题 You issue the following command on the RMAN prompt. RMAN REPORT NEED BACKUP DAYS = 5 DATABASE； Which statement is true about executing this command？（）A、 It will display a list of files that need incremental backup.B、 It will display a list of files that need backup after five days.C、 It will display a list of files that were backed up in the last five days.D、 It will display a list of files that have not been backed up in the last five days.E、 It will apply the current retention policy to determine the files that need to be backed up.

查看答案

考题单选题In which scenario， will you issue the following command？（） RMAN REPORT NEED BACKUP DAYS 7；A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days

查看答案

考题单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy： CONFIGURE RETENTION POLICY TO REDUNDANCY 3； Which statement is true？（）A The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB Backup optimization is performed， but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC Backup optimization is permanently disabledD Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

查看答案

考题单选题You issue the following RMAN command to set a retention policy on a database： RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2； What will be the outcome of issuing this command？（）A After two days，a backup will be marked obsoleteB After two days，a backup will be deleted from the mediaC If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

查看答案

考题单选题Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?（）A The RMAN backup fails because the TOOLS tablespace is read-onlyB The RMAN skips the backup of the tablespace because backup optimization is enabledC The RMAN makes backup because optimization can be enabled only for backups to diskD The RMAN makes the backup because no backup of the tablespace exists within the seven day window

查看答案

考题单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题单选题In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?（）A Only one channel is allocated and the backup is created in the flash recovery areaB Only one channel is allocated and the backup is created in the destination specified for channel 1C Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

查看答案

考题单选题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.

查看答案

考题单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）A Place the root container in ARHCHIVELOG mode.B Take the user data tablespace offline.C Place the root container in the nomount stage.D Ensure that HR_PDB is open.

查看答案

考题单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.

查看答案

考题单选题You issue the following command： RMANCONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）A An incremental backup strategy will be used automatically.B Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.C RMAN will configure itself for maximum performance at the cost of CPU.D RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.E RMAN will automatically compress backups.

查看答案

考题单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?（）A After two days, a backup will be marked obsoleteB After two days, a backup will be deleted from the mediaC If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.D If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

查看答案

考题单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

查看答案

考题单选题You enable block change tracking. You issue the following command： BACKUP INCREMENTAL LEVEL 0 DATABASE； The next day，you issue the following command： BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE； Which statement about the use of the change tracking file is true？（）A RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B RMAN reads the block change tracking file when it performs both incremental backups.C RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D RMAN does not read the block change tracking file when it performs either incremental backup.

查看答案

考题单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

查看答案

考题单选题You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL CREATE TABLESPACE rman_ts DATAFILE ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts； Which command should you issue next？（）A RESYNC CATALOG；B REGISTER DATABASE；C CREATE CATALOG TABLESPACE rman_ts；D GRANT recovery_catalog_owner TO rman_db01；

查看答案

考题多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

查看答案

考题单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace： RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M； Which statement is true about executing this command？（）A The command generates an error.B The command backs up the tablespace and creates a backup set of size 200 MBC The command backs up the tablespace and creates two backup sets of size 100 MB each.D The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

查看答案

考题多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile

查看答案

考题单选题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？（）A target databaseB auxiliary databaseC third-party databaseD recovery catalog database

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：