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

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

Examine the following RMAN command:   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06;   Which two statements are true regarding the backup taken by using the above RMAN command?()  

  • A、 Only data files and the control file are backed up.
  • B、 Archived redo logs are backed up only if the database is open during the backup.
  • C、 The backup is deleted after one day,regardless of the default retention policy settings. 
  • D、 The backup becomes obsolete after one day,regardless of the default retention policy settings.

参考答案

更多 “ Examine the following RMAN command:   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06;   Which two statements are true regarding the backup taken by using the above RMAN command?()  A、 Only data files and the control file are backed up.B、 Archived redo logs are backed up only if the database is open during the backup.C、 The backup is deleted after one day,regardless of the default retention policy settings. D、 The backup becomes obsolete after one day,regardless of the default retention policy settings.” 相关考题
考题 You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?()A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 Examine the following RMAN command:Which two statements are true regarding the backup taken by using the above RMAN command?() A. Only data files and the control file are backed up.B. Archived redo logs are backed up only I f the database is open during the backup.C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

考题 You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?() A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

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

考题 You issued the following commands to configure setting in RMAN;RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?()A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two) A. The KEEP option overrides the configured retention policyB. The KEEP option is an attribute of an individual backup pieceC. The backup contains only data files and archived redo log filesD. The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

考题 Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

考题 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?()A、 The copy of the datafile created is stored in the RMAN repository.B、 The copy of the datafile created can be viewed using the LIST BACKUP command.C、 The copy of the datafile created using this COPY command can be placed only on the disk.D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from 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

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

考题 You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()A、 The backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.B、 The KEEP option overrides the configured retention policy.C、 The backup contains only data files and archived redo log files.D、 The KEEP option is an attribute of an individual backup piece.

考题 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 backups B、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 consumed.D、Using this command to create backups improves the performance of the backup process 

考题 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 the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.B、 The backup piece size will be limited to 300 MB.C、 The operation is accomplished using the default channel available.D、 Three channels for the tape drive must be configured by setting the parallelism to three.

考题 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?()A、 The block change tracking data will be used only from the next incremental 0 backup.B、 The incremental backup will use change tracking data for accomplishing the backup.C、 The incremental backup will not use change tracking data for accomplishing the backup.D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

考题 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 performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)A、The KEEP option overrides the configured retention policyB、The KEEP option is an attribute of an individual backup pieceC、The backup contains only data files and archived redo log filesD、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

考题 Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:   RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;  DUPLICATE TARGET DATABASE TO auxdb; }   Which statement is true about the duplicate database in this scenario?()  A、 It contains data till the last backupB、 It contains all data from target database until the current timeC、 It contains all data from only the committed transactions in the target databaseD、 It contains all data except that which is used by the transactions in the current online redo file of target database

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

考题 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?()A、The block change tracking data will be used only from the next incremental 0 backup.B、The incremental backup will use change tracking data for accomplishing the backup.C、The incremental backup will not use change tracking data for accomplishing the backup.D、The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

考题 多选题You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup?()AThe backup contains data files, the server parameter file,and the control file even if the control file autobackup is disabled.BThe KEEP option overrides the configured retention policy.CThe backup contains only data files and archived redo log files.DThe KEEP option is an attribute of an individual backup piece.

考题 多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

考题 多选题Examine the following RMAN command:   BACKUP DATABASE TAG TESTDB  KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06;   Which two statements are true regarding the backup taken by using the above RMAN command?()AOnly data files and the control file are backed up.BArchived redo logs are backed up only if the database is open during the backup.CThe backup is deleted after one day,regardless of the default retention policy settings.DThe backup becomes obsolete after one day,regardless of the default retention policy settings.

考题 单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

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

考题 单选题Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN STARTUP MOUNT  2. RMAN RESTORE DATABASE;  3. RMAN ()  4. RMAN ALTER DATABASE OPEN;A RECOVER DATABASE;B SWITCH DATAFILE ALL;C RESTORE CONTROL FILE;D RECOVER DATABASE USING BACKUP CONTROL FILE;