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

题目内容 (请给出正确答案)
单选题
Which RMAN backup command is used to create the block-change tracking file?()
A

 alter database create block change tracking file

B

 alter database enable block change file

C

 alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.fil

D

 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’

E

 alter system block change tracking on


参考答案

参考解析
解析: 暂无解析
更多 “单选题Which RMAN backup command is used to create the block-change tracking file?()A  alter database create block change tracking fileB  alter database enable block change fileC  alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.filD  alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’E  alter system block change tracking on” 相关考题
考题 The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()A、data filesB、backup setsC、control filesD、archived redo log files

考题 Which command is used to configure RMAN to perform a compressed backup for every backup executed?()A、 BACKUP AS COMPRESSED BACKUPSET DATABASEB、 BACKUP AS COMPRESSED COPY OF DATABASEC、 CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSETD、 CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS E、 BACKUP DATABASE COMPRESS

考题 Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?()A、 Backup compression is disabled by default.B、 Backup compression can be used with both backup sets and image copies.C、 Backup compression cannot be enabled using the CONFIGURE command.D、 Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.E、 Backup compression applies to only backup sets.F、 Backup compression applies to only image copies.

考题 You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 What is the purpose of the catalog command?()  A、 To review RMAN control file and recovery catalog metadata and ensure that its correctB、 To delete RMAN backup-related metadata from the recovery catalogC、 To create metadata in the control file and the recovery catalog related to backup set pieces D、 To create a report that lists database backupsE、 To rebuild the recovery catalog

考题 Which RMAN backup command is used to create the block-change tracking file?()  A、 alter database create block change tracking fileB、 alter database enable block change fileC、 alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.filD、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’E、 alter system block change tracking on

考题 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 executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()  A、 A list of files that require a backup within 3 daysB、 A list of files requiring more than 3 days of archivelogs to applyC、 A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

考题 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?()A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository

考题 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?()  A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

考题 You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process

考题 You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()A、 BACKUP AS BACKUPSETB、 BACKUP AS COPYC、 BACKUP AS COMPRESSED BACKUPSETD、 BACKUP INCREMENTAL LEVEL n CUMULATIVE

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

考题 多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

考题 多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’;   Which two statements are true regarding the backup created using this command?()AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.

考题 单选题What is the purpose of the catalog command?()A  To review RMAN control file and recovery catalog metadata and ensure that its correctB  To delete RMAN backup-related metadata from the recovery catalogC  To create metadata in the control file and the recovery catalog related to backup set pieces D  To create a report that lists database backupsE  To rebuild the recovery catalog

考题 单选题You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage?()A  BACKUP AS BACKUPSETB  BACKUP AS COPYC  BACKUP AS COMPRESSED BACKUPSETD  BACKUP INCREMENTAL LEVEL n CUMULATIVE

考题 多选题The RMAN BACKUP command using the DELETE INPUT option can be used with which three types of files? ()Adata filesBbackup setsCcontrol filesDarchived redo log files

考题 单选题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?()A  MAXSETSIZE TO 2B  DEVICE TYPE DISK PARALLELISM 2C  RETENTION POLICY TO REDUNDANCY 2D  DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

考题 多选题You issue this RMAN command:   RMAN create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   (database include current controlfile);   sql ‘alter database archive log current’;   }  Which three statements are true about the Level0Backup script you just created?()AThe script is stored only in the control file.BThe script is stored only in the recover catalog.CThe script can be executed only by using the RMAN RUN command.DThe commands of the script can be displayed with the LIST command.EThe commands of the script can be displayed with the PRINT command.FThe commands of the script can be displayed with the REPORT command.

考题 单选题You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist.  Which command should you now use to check if any of the files were missing?()A LIST EXPIREDB DELETE EXPIREDC DELETE OBSOLETED CHANGE UNCATALOG

考题 单选题You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()A A different procedure is required to restore a database from compressed backupsB The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C Using this command to create backups minimizes the bandwidth consumedD Using this command to create backups improves the performance of the backup process

考题 单选题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?()A CHANGEB RESYNCC CATALOGD CROSSCHECK

考题 单选题Which RMAN command is used to verify the status of a backup or copy, and also updates the repository when files have been deleted using operating system commands?()A CHANGEB RESYNCC CATALOGD CROSSCHECK

考题 单选题Which RMAN backup command is used to create the block-change tracking file?()A  alter database create block change tracking fileB  alter database enable block change fileC  alter database enable block change tracking using file ,/ora01/opt/ block_change_tracking.filD  alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’E  alter system block change tracking on

考题 单选题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?()A cannot be used in RMANB by starting up the database againC by using the CATALOG command of RMAND by using the RECOVER CATALOG command in RMANE by re-creating the target control file to rebuild the RMAN repository

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

考题 单选题Which command is used to configure RMAN to perform a compressed backup for every backup executed?()A  BACKUP AS COMPRESSED BACKUPSET DATABASEB  BACKUP AS COMPRESSED COPY OF DATABASEC  CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSETD  CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS E  BACKUP DATABASE COMPRESS