6. In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is
set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery
Manager (RMAN)?
A. The backup would be retained on the media for 31 days.
B. The backup would be maintained in the recovery catalog for 31 days.
C. The backup metadata would be retained in the control file for 31 days.
D. The backup metadata would be maintained in the recovery catalog for 31 days.
E. Automatic backups of the control file will be retained in the flash recovery area for 31 days.
Answer:C
———————
7. 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.
Answer:D
—————–
8. 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-03009: failure of allocate command on c1 channel
ORA-19554: 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.
Answer:B
————————
9. View the Exhibit.
You executed the following command to perform a backup of the USERS tablespace:<
RMAN> BACKUP TABLESPACE USERS;
Which three types of files are backed up? (Choose three.)
A. password file
B. online redo log files
C. the current control file
D. archived redo log files
E. the current server parameter file
F. all the data files belonging to the USERS tablespace
G. data files belonging to the USERS tablespace and all the default tablespaces
Answer:CEF
———————–
10. You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS
tablespace:
RMAN> BACKUP TABLESPACE DETTBS;
Under which conditions would this command execute successfully? (Choose all that apply.)
A. The database is in NOMOUNT state.
B. The database is in ARCHIVELOG mode and the tablespace is online.
C. The database is in ARCHIVELOG mode and the tablespace is offline.
D. The database is in NOARCHIVELOG mode and the tablespace is online.
E. The database is in NOARCHIVELOG mode and the tablespace is offline.
Answer:BCE
More Infomation Visit: