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

题目内容 (请给出正确答案)

In RMAN, when the RESYNC CATALOG command is issued, in which two situations does the command file actually perform synchronization?()

  • A、After the COPY command.
  • B、After adding a data file in the target database.
  • C、After adding a tablespace in the target database.
  • D、After adding a tablespace in the catalog database.
  • E、After dropping a data file in the catalog database.
  • F、After running SQL Loader to load a large amount of data.

参考答案

更多 “In RMAN, when the RESYNC CATALOG command is issued, in which two situations does the command file actually perform synchronization?()A、After the COPY command.B、After adding a data file in the target database.C、After adding a tablespace in the target database.D、After adding a tablespace in the catalog database.E、After dropping a data file in the catalog database.F、After running SQL Loader to load a large amount of data.” 相关考题
考题 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

考题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) to perform backups in your databases. Which four backup operations can be performed using RMAN?()A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online, read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online, read/write data files when the database is in the NOMOUNT state.

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

考题 RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()A、’SQL ALTER DATABASE OPEN’;B、SQL ALTER DATABASE ’OPEN’;C、OPEN DATABASE;D、DATABASE OPEN

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

考题 When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()A、RMAN keeps a list of archive logs in a text file.B、The DBA must manually tell RMAN which archive logs to backup.C、RMAN has access to target control file and/or catalog information.D、RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

考题 When youre performing active database duplication,a backup of what kind is required?()  A、 A current RMAN backup-set backup is required.B、 No backup is required.C、 An RMAN image backup is required.D、 A manual backup is required.E、 A "duplicate" preparatory backup is required.

考题 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 issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

考题 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 a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()A、data fileB、password fileC、archivelog fileD、temporary fileE、online redo log fileF、the current control fileG、the tnsnames.ora fileH、current server parameter file

考题 When issuing the CROSSCHECK command in RMAN, if a backup file CANNOT be found, to what status is that file set?()A、DELETEDB、OBSOLETEC、EXPIREDD、UNKNOWN

考题 Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题Which statement about using RMAN stored scripts is true?()A  To create and execute an RMAN stored script,you must use a recovery catalog.B  When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C  RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D  When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

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

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

考题 多选题When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file

考题 多选题When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUPcommand? ()Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file

考题 单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()A Because the progress is reported for each data fileB Because the progress is reported for each backup setC Because other RMAN sessions have issued the same BACKUP commandD Because new data files have been added to the database while the RMAN backup is in progress

考题 单选题You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A  When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B  When a structural change is made to the database, then a backup of the current control file is performed.C  When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D  When a structural change is made to the database, then a backup of the alert log file will be performed.

考题 多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN?()Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit

考题 单选题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 work as a database administrator for Certkiller .com. You are using Recovery Manager (RMAN) to perform backups in your databases.  Which four backup operations can be performed using RMAN?()AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online, read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online, read/write data files when the database is in the NOMOUNT state.

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

考题 单选题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 have configured the following:  RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters:  CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 1; # CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  RMAN CONFIGURE DEVICE TYPE SET PARALLELISM 5;  RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 5; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  How many channels are allocated to SBT?()A 0, because channels have not been defined.B 3, as indicated by the degree of parallelism.C 1, the default value when device is configured.D 5, as indicated by the last parallelism command.