网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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” 相关考题
考题
Examine the following RMAN script: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
考题
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.
考题
Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()
A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
考题
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
考题
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
考题
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
考题
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?() A、 run { open script backup_database; run script backup_database }B、 run { engage script backup_database; }C、 run { run script backup_database; }D、 Run { execute script backup_database; }E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
考题
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script
考题
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.()A、 The data file backup is done with multiple channelsB、 The data files is in the read-write mode after being backed up in the read only modeC、 The backup was taken after the data files was taken offline-normal or is in the read only modeD、 The data file backup complies with the back retention policy and the backup duplexing fe ture
考题
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
考题
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: RMAN RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; } What is the multiplexing level in the preceding backup process?()A、 4B、 8C、 7D、 0
考题
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
考题
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 execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows: RMAN/x7f03009: failure of allocate command on c1 channel ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name: What could explain why the statement failed?()A、sbt is not a valid device type.B、Media Management Library was not loaded.C、The sbt device cannot be used for data file backups.D、No path was defined in the ALLOCATE CHANNEL command.E、The channel is currently being used by another RMAN session.
考题
Given the script create script db_backup_datafile_script {backup datafile and 1, and2 plus archivelog delete input;} Run {execute script db_backup_datafile_script using 2;} What is the result of running this command?() A、 The script will fail since you instructed RMAN to back up only one datafile rather than twoB、 The script will successfully back up datafile 3 without errorC、 The script will fail since it uses a substitution variable which is not supportedD、 The execute script command will prompt for the value of and2 since it’s not included in the commandE、 The script will fail because you cannot use the plus archivelog command when backing up
考题
单选题You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()A
run { open script backup_database; run script backup_database }B
run { engage script backup_database; }C
run { run script backup_database; }D
Run { execute script backup_database; }E
The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
考题
单选题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
考题
单选题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
考题
单选题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
考题
单选题View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation: RMAN RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; } What is the multiplexing level in the preceding backup process?()A
4B
8C
7D
0
考题
单选题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
考题
单选题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.
考题
单选题Given the script create script db_backup_datafile_script {backup datafile and 1, and2 plus archivelog delete input;} Run {execute script db_backup_datafile_script using 2;} What is the result of running this command?()A
The script will fail since you instructed RMAN to back up only one datafile rather than twoB
The script will successfully back up datafile 3 without errorC
The script will fail since it uses a substitution variable which is not supportedD
The execute script command will prompt for the value of and2 since it’s not included in the commandE
The script will fail because you cannot use the plus archivelog command when backing up
考题
单选题You execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows: RMAN/x7f03009: failure of allocate command on c1 channel ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name: What could explain why the statement failed?()A
sbt is not a valid device type.B
Media Management Library was not loaded.C
The sbt device cannot be used for data file backups.D
No path was defined in the ALLOCATE CHANNEL command.E
The channel is currently being used by another RMAN session.
考题
单选题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 scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A
It is a SQL script.B
It is a PL/SQL file.C
It is an operating system (OS) file.D
It is a Recovery Manager (RMAN) script
热门标签
最新试卷