0
1
3
4
第1题:
hich of the following RMAN structures can data from a datafile span?()
第2题:
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?()
第3题:
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?()
第4题:
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?()
第5题:
You are performing a backup of your database across the network. While taking the backup, you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup?()
第6题:
CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY;
CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY;
第7题:
RMAN backup-set pieces spanning backup sets
RMAN backup-set pieces within a given backup set
RMAN backups
RMAN channels
None of the above
第8题:
0, because channels have not been defined.
3, as indicated by the degree of parallelism.
1, the default value when device is configured.
5, as indicated by the last parallelism command.
第9题:
RMAN backup-set pieces spanning backup sets
RMAN backup-set pieces within a given backup sets
RMAN backups
RMAN channels
None of the above
第10题:
The script will fail since you instructed RMAN to back up only one datafile rather than two
The script will successfully back up datafile 3 without error
The script will fail since it uses a substitution variable which is not supported
The execute script command will prompt for the value of and2 since it’s not included in the command
The script will fail because you cannot use the plus archivelog command when backing up
第11题:
BACKUP AS COMPRESSED BACKUPSET DATABASE
BACKUP AS COMPRESSED COPY OF DATABASE
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
BACKUP DATABASE COMPRESS
第12题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第13题:
Which command is used to configure RMAN to perform a compressed backup for every backup executed?()
第14题:
What is the impact of the results of the output of the following command?() RMAN> report unrecoverable database; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name 4 full or incremental C:///ORACLE/ORADATA/ORCL/USERS01.DBF
第15题:
Which of the following RMAN structures can data from a datafile span?()
第16题:
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?()
第17题:
You notice that your RMAN script used to copy the datafiles, control files, and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands?()
第18题:
The data file is checked for physical corruption and backed up if found clean.
The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
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.
The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
第19题:
Only one channel is allocated and the backup is created in the flash recovery area
Only one channel is allocated and the backup is created in the destination specified for channel 1
Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
第20题:
There are no backup sets with any backups of the users01.dbf datafile.
The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
The users01.dbf datafile is corrupted.
The users01.dbf datafile backup exceeds the retention criteria.
The last backup of the users01.dbf datafile failed and must be rerun.
第21题:
V$BACKUP
V$BACKUP_STATUS
V$BACKUP_DATAFILE
V$DATAFILE_BACKUP
V$TABLESPCE_BACKUP
第22题:
0
1
3
4
第23题:
0, because channels have not been defined.
3, as indicated by the degree of parallelism.
1, the default value when device is configured.
5, as indicated by the last parallelism command.
第24题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2