Free Oracle 1z0-034 Exam Dumps Questions & Answers

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)

• A.setting the FAST_START_MTTR_TARGET to set the mean time to recover
• B.using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.
• C.using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
• D.setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

In which two aspects does hot patching differ from conventional patching? (Choose two.)

• A.It consumes more memory compared with conventional patching.
• B.It does not require down time to apply or remove unlike conventional patching.
• C.It takes more time to install or uninstall compared with conventional patching.
• D.It can be installed and uninstalled via OPatch unlike conventional patching.
• E.It is not persistent across instance startup and shutdown unlike conventional patching.

Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP
INCREMENTAL LEVEL = 0
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true regarding the approach in the command?

• A.It is a case of parallelization of the backup set.
• B.It is an implementation of a multisection backup.
• C.The RMAN multiplexing level is 4.
• D.It is the use of asynchronous I/O by RMAN.

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.

• A.To store the backup information of multiple database
• B.To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
• C.To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D.To restrict the amount of space that is used by the backups

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

• A.all disks in the disk group only if all of them are ONLINE
• B.all disks in the disk group
• C.all disks that are not currently in OFFLINE mode
• D.all disks that are currently in OFFLINE mode