-
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()
A . RMAN image copies.
B . RMAN database backups.
C . RMAN tablespace backups.
D . User-managed backups placed in the flash recovery area.
E . User-managed backups that have been cataloged with RMAN.
F . User-managed data file backups for which the pull path name is specified.
-
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file, current SPFILE file, data files, and archived redo log
-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?() (Choose two).
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
A . The tape I/O performed is asynchronous
B . The tape buffer is allocated from the System Global Area (SGA)
C . The tape buffer is allocated from the Program Global Area (PGA)
D . Oracle I/O uses an interrupt mechanism to determine when each I/O complete
-
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 encryption
B . Set up an Oracle wallet for the encryption
C . No setup is required as it is a default encryption method
D . Both Oracle wallet and password must be set up for the encryptio
-
You run the following commands: RMAN> list expired backup; RMAN> delete expired backup; What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()
A . They will be renamed.
B . Nothing will happen to them. The backup set pieces do not exist.
C . They will be deleted immediately since they are not in the flash recovery area.
D . You will need to manually remove the physical files listed in the output of the commands.
E . They will become hidden files and removed 10 days later.
-
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
A . RMAN image copies
B . RMAN database backups
C . RMAN tablespace backups
D . usermanaged backups placed in the flash recovery area
E . usermanaged backups that have been cataloged with RMAN
F . usermanaged data file backups for which the full path name 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 encryption
B . Set up an Oracle wallet for the encryption
C . No setup is required as it is a default encryption method
D . Both Oracle wallet and password must be set up for the encryptio
-
The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()
A . The tape I/O performed is asynchronous
B . The tape buffer is allocated from the System Global Area (SGA)
C . The tape buffer is allocated from the Program Global Area (PGA)
D . Oracle I/O uses an interrupt mechanism to determine when each I/O complete
-
You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements are true about these backups()
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure.
-
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
A . The backups would be consistent.
B . The backups would be inconsistent.
C . The backups would be possible only if the database is running in ARCHIVELOG mode.
D . The backups would be possible only if the database is running in NOARCHIVELOG mode.
E . The backups need to be restored and the database has to be recovered in case of a media failure
-
An RMAN backup job fails, displaying the following error: ORA19809: limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future?()
A . take the backup of the flash recovery area less frequently
B . increase the value of the UNDO_RETENTION initialization parameter
C . change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
D . change the backup retention policy to retain the backups for a smaller period of time
E . increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
F . increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?()
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
You are trying to deploy a configuration job to an ios access point using the wlse, but the job fails. Which of the following would cause this failure?()
A . snmp communities
B . telnet/ssh user/password
C . wlccp credentials
D . http user/password
-
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause. Which components are backed up when this option is specified?()
A . only the control file, the current SPFILE, and data files
B . only the current SPFILE and data files if autobackup is disabled
C . only the data files and the archived redo logs
D . the control file,current SPFILE file,data files,and archived redo log
-
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 encryption
B . Set up an Oracle wallet for the encryption
C . No setup is required as it is a default encryption method
D . Both Oracle wallet and password must be set up for the encryptio
-
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
A . Only the data files.
B . Only the data files and the online logs.
C . The data files, control files, and the online logs.
D . The data files and control files, but not the online logs.
-
When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUP command?()
A . data file
B . password file
C . archivelog file
D . temporary file
E . online redo log file
F . the current control file
G . the tnsnames.ora file
H . current server parameter file
-
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 encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption
-
Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?()1.shutdown immediate from RMAN2.Log into RMAN3.startup mount from RMAN4.backup database5.alter database open6.backup database plus archivelog delete input
A.2,3,1,4,5
B.2,1,3,6,5
C.1,3,5,4
D.2,1,3,5,6
E.2,1,3,4,5
-
You are the network administrator for The network consists of a single Active Directory domain named All servers run Windows Server 2003.A member server named TestKing3 hosts files and folders. On TestKing3, you configure a normal backup to run every night. The backup data will be saved to magnetic tape, and a detailed log file will be generated. The backup job will use an account named BackupUser, which is a member of the Backup Operators group.One week later, you use your Administrator account credentials to log on to TestKing3. You start the Backup utility. However, no backup logs are available.You need to verify that the backup jobs are completing successfully.What should you do?()
A.Use a text editor to open C:\windows\security\logs\Backup.log. Search for the dates when backups were scheduled.
B. Start the Backup utility by using the Run As option. Provide the account credentials of BackupUser. From the Tools menu, select Report, and then select the most recent report.
C. Open the Removable Storage snap-in. Examine the properties of the most recently completed Work Queue object.
D. Open the Removable Storage snap-in, and then open the properties of the Operator Requests object. On the General tab, clear the Automatically delete completed requests option
-
Your network consists of a single Active Directory domain.You have a server named Server1. Server1 has only one hard disk drive.You run a full backup at 02:00 every Monday. You run an incremental backup at 02:00 every Tuesday toSunday. You run an Automated System Recovery (ASR) backup every day at 13:00.Server1’s hard disk drive fails on Wednesday at 15:00.You need to recover Server1 to its latest configuration by using the minimum amount of administrativeeffort.What should you restore? ()
A. Monday’s full backup, then Tuesday’s incremental backup, and then Wednesday’s incremental backup
B. Monday’s full backup and then Wednesday’s ASR backup
C. Monday’s full backup and then Wednesday’s incremental backup
D. Wednesday’s ASR backup
-
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 afterreaching 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