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

题目内容 (请给出正确答案)
单选题
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()
A

Because the progress is reported for each data file

B

Because the progress is reported for each backup set

C

Because other RMAN sessions have issued the same BACKUP command

D

Because new data files have been added to the database while the RMAN backup is in progress


参考答案

参考解析
解析: 暂无解析
更多 “单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()A Because the progress is reported for each data fileB Because the progress is reported for each backup setC Because other RMAN sessions have issued the same BACKUP commandD Because new data files have been added to the database while the RMAN backup is in progress” 相关考题
考题 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

考题 View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process() A. 4B. 8C. 7D. 0

考题 Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()A. Implement RMAN multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

考题 View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

考题 Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED

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

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

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()A、The database instance is running with manual PGA management.B、The database instance is running with manual shared memory management.C、The database instance has the MEMORY_TARGET value set to a nonzero value.D、All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed

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

考题 Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()A、Data files that belong to only the root containerB、Data files that belong to the root container and all the pluggable databases (PDBs)C、Data files that belong to only the root container and PDB$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED

考题 You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files:  $ rman target /  What would be the effect of this command?()A、RMAN would use the current operating system location to place the backup.B、RMAN would use the control file of the target database to maintain the backup.C、RMAN would use the recovery catalog of the target database to maintain the backup.D、RMAN would use the control file of the target database to maintain the backup metadata. E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

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

考题 View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()A、Because the progress is reported for each data fileB、Because the progress is reported for each backup setC、Because other RMAN sessions have issued the same BACKUP commandD、Because new data files have been added to the database while the RMAN backup is in progress

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

考题 Examine this statement:  RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2;  What state must the target database be in for you to use this RMAN command?()A、The target database must be open.B、The target database must be closed.C、The target database must be mounted.D、The target database must be mounted or open.

考题 单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A  RMAN would use the current operating system location to place the backup.B  RMAN would use the control file of the target database to maintain the backup.C  RMAN would use the recovery catalog of the target database to maintain the backup.D  RMAN would use the control file of the target database to maintain the backup metadata.E  RMAN would use the recovery catalog of the target database to maintain the backup metadata.

考题 单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()A Because the progress is reported for each data fileB Because the progress is reported for each backup setC Because other RMAN sessions have issued the same BACKUP commandD Because new data files have been added to the database while the RMAN backup is in progress

考题 单选题View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()A The database instance is running with manual PGA management.B The database instance is running with manual shared memory management.C The database instance has the MEMORY_TARGET value set to a nonzero value.D All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed

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

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

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

考题 单选题Examine this statement:  RMAN BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2;  What state must the target database be in for you to use this RMAN command?()A The target database must be open.B The target database must be closed.C The target database must be mounted.D The target database must be mounted or open.

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

考题 单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()A Data files that belong to only the root containerB Data files that belong to the root container and all the pluggable databases (PDBs)C Data files that belong to only the root container and PDB$SEEDD Data files that belong to the root container and all the PDBs excluding PDB$SEED