2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (61-70)
You are performing an online backup of a data file. During the backup, the database writer is in the middle of updating a block when RMAN tries to read the same block. What would RMAN do?
A. RMAN terminates the backup operation with an error.
B. RMAN performs backup of all other blocks except this block.
C. RMAN performs image copy backups automatically in such cases.
D. RMAN rereads the block until it gets a consistent picture of the data.
Which statement is true regarding database writer process (DBWn)?
A. It writes only committed data to the data files.
B. It synchronizes the database buffer cache and the data files regularly.
C. It makes changes to data blocks in the database buffer cache when required.
D. It is possible to configure more than one database writer process, but this is useful only on uniprocessor
You are using Recovery Manager (RMAN) to back up your database at regular intervals. You are using recovery catalog to maintain the RMAN repository. On a Monday, while trying to back up a data file you realize that the recovery catalog database is down and you decide to back up the data file by using an operating system command.
On Tuesday, after the recovery catalog database is functional you execute the following command to register the previous day’s backup in the RMAN repository:
RMAN> CATALOG DATAFILECOPY ‘/u01/oracle/backup/users01.dbf’;
How can this backup be used to recover the data file in case of a corruption?
A. as a zero-level base backup for the incremental backups
B. as the lowest nonzero-level backup for the incremental backups
C. as the highest nonzero-level backup for the incremental backups
D. as the highest nonzero-level backup that requires the archived redo log files only
You are working in an Oracle Shared Server environment. You added one more dispatcher to handle TCP requests. How would you verify that the dispatcher has been registered when the instance was started?
A. by checking the entries in the listener.ora file
B. by checking the entries in the initialization parameter file
C. by checking the output of the lsnrctl show command
D. by checking the output of the lsnrctl services command
You are working on a database and instance failure has occurred due to a power outage. You want to bring the instance up. From what point in the redo log file does instance recovery begin and where does it end?
A. from the checkpoint position to the end of the redo log file
B. from the beginning of the oldest online redo log file to the checkpoint position
C. from the beginning of the current redo log file to the end of inactive redo log file
D. from the beginning of the inactive redo log file to the end of current redo log file
Which two statements regarding backup sets are true? (Choose two.)
A. A backup set may contain both data files and control files.
B. Each file in a backup set must have the same Oracle block size.
C. A backup set may contain both data files and archived redo log files.
D. A backup set may contain both a control file and archived redo log files.
You have set the control file autobackup to ON by using the following command in the Recovery Manager (RMAN):
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically? (Choose two.)
A. when a tablespace is added
B. when the database instance is restarted
C. when a successful backup is recorded in the RMAN repository
D. when the RMAN connection is disconnected from the target database
The database writer (DBWn) uses the checkpoint queue to identify blocks while writing data from the database buffer cache to data files. What type of information is stored in each entry of the checkpoint queue? (Choose three.)
A. data file name
B. data block size
C. data file number
D. redo log file name
E. data block number
F. tablespace number
G. the Redo Byte Address (RBA)
You are using operating system tools or utilities to back up your production database. Your organization decides to use Recovery Manager (RMAN) to back up the database starting from next Monday and you have been asked to register all operating system (OS) backups in the RMAN repository. Which RMAN command would you use for this?
E. CREATE CATALOG
Your database is configured for shared server. A particular client requires a dedicated server. Select two actions that you can perform to configure the client to use a dedicated server. (Choose two.)
A. configuring the listener.ora file with USE_DEDICATED_SERVER=on
B. configuring the client profile (sqlnet.ora file) with USE_DEDICATED_SERVER=on
C. specifying the SESSIONS=1 attribute for the DISPATCHERS parameter in the initialization parameter file
D. configuring a net service name with a connect descriptor that contains (server=dedicated) in the
If you want to pass Oracle 1Z0-032 successfully, donot missing to read latest lead2pass Oracle 1Z0-032 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.