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

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

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” 相关考题
考题 Examine the following RMAN command:RMAN CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?() A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption

考题 Examine the following RMAN script:RMAN run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?() A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

考题 For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、user­managed backups placed in the flash recovery areaE、user­managed backups that have been cataloged with RMANF、user­managed data file backups for which the full path name is specified

考题 hich of the following RMAN structures can data from a datafile span?()A、RMAN backup-set pieces spanning backup sets B、RMAN backup-set pieces within a given backup sets C、RMAN backups D、RMAN channels E、None of the above

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

考题 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 want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?()A、RMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEB、RMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASEC、RMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE D、RMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE

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

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

考题 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 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 RMAN command:   RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG;   Which prerequisite must be met before accomplishing the backup?()A、 Provide a password for the encryptionB、 Set up an Oracle wallet for the encryptionC、 No setup is required as it is a default encryption methodD、 Both Oracle wallet and password must be set up for the encryption

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

考题 Which of the following RMAN structures can data from a datafile span?()A、 RMAN backup-set pieces spanning backup setsB、 RMAN backup-set pieces within a given backup setC、 RMAN backupsD、 RMAN channelsE、 None of the above

考题 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 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?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、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).

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

考题 单选题Examine the following RMAN command: RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()A Provide a password for the encryptionB Set up an Oracle wallet for the encryptionC No setup is required as it is a default encryption methodD Both Oracle wallet and password must be set up for the encryption

考题 单选题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 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.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

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

考题 单选题Consider the following scenario for your database: 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

考题 单选题Examine the following RMAN script:   RMAN run { debug on;  allocate channel c1 type disk; backup datafile 5; }   Which statement describes the purpose of the script?()A  The data file is checked for physical corruption and backed up if found clean.B  The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C  The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D  The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

考题 单选题As A DBA, which of the following methods can you use to make a backup of your table?()A Recover Manager (RMAN) utilityB Import utilityC Export utilityD O/S backup command

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

考题 单选题Which of the following RMAN structures can data from a datafile span?()A  RMAN backup-set pieces spanning backup setsB  RMAN backup-set pieces within a given backup setC  RMAN backupsD  RMAN channelsE  None of the above

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