2014 Latest Pass4sure&Lead2pass Oracle 1Z0-032 Exam Questions (51-60)
When starting up the test database, you encounter the following error after mounting the database:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: ‘/u01/oracle/app/oradata/log2.log’
ORA-27037: unable to obtain file status
While investigating the reason, you find that the status of the redo log group 2 is CURRENT. Which type of recovery would you perform to ensure that the database is functional?
A. Open Database recovery
B. Time-Based incomplete recovery
C. recovery using the backup control file
D. Cancel-Based incomplete recovery
E. Change-Based incomplete recovery
You received this error message because Oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration file:
ORA-12154: TNS:could not resolve service name
Which three actions would be appropriate in helping to resolve the error? (Choose three.)
A. Verify the naming method is set to host naming.
B. Verify that a tnsnames.ora file exists and that it is accessible.
C. Verify that a listener on the client node exists and has been started.
D. Verify that the tnsnames.ora file is in the location specified by the TNS_ADMIN environment variable.
E. Verify the NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME) parameter is set in the initialization
F. Verify that the service name specified in your connection string matches a named entry in the tnsnames.ora file.
Your database is configured with two mandatory archive destinations and three optional archive destinations. What would happen if the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter is set to 4?
A. Oracle database can reuse logs only if all the optional archive destinations succeed.
B. Oracle database ignores this parameter if mandatory archive destinations are configured.
C. Oracle database can reuse redo log files even if no optional archive destination succeeds.
D. Oracle database can reuse redo log files only if at least two optional archive destinations succeed.
E. Oracle database returns an error as the value assigned to this parameter should not be more than the
number of mandatory archive destinations.
When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations? (Choose three.)
A. at the end of every RUN block
B. after every SET CONTROLFILE AUTOBACKUP FORMAT command
C. after every BACKUP or COPY command issued at the RMAN prompt
D. at the end of every RUN block if the last command in the block was either BACKUP or COPY
E. whenever a BACKUP or COPY command within a RUN block is followed by a command that is
neither BACKUP nor COPY
F. after every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE
CONTROLFILE AUTOBACKUP FORMAT command
You want to perform a backup of the control file by using the following command:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
In which situation would the command fail?
A. The database is in the MOUNT state.
B. The database is in the NOMOUNT state.
C. The database has multiplexed control files
D. The database is opened and is in read-only mode.
Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashes and you now want to use the backups from last night. What do you need to do?
A. You need to perform the restore and recovery operations manually, because the backup was made manually.
B. First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover
C. First you need to add the backup to the catalog using the CATALOG command, and then you can use
RMAN to recover the database.
D. You can just use RMAN and recover the database, because RMAN automatically updates the catalog
with the backup information.
You want to insert rows into the ORDERS_HISTORY table from the ORDERS table on the last working day of every month. To accomplish this task, you execute the following command:
INSERT /* +APPEND */ INTO orders_history
SELECT * FROM orders;
Which blocks of the ORDERS_HISTORY table segment would be used to accommodate the data from the ORDER table?
A. only the block that is below the high water mark
B. only the blocks that are above the high water mark
C. only the blocks where PCTFREE is never used
D. any blocks that are listed in the free list of the segment
E. only the blocks where the used space is less than PCTUSED
Using Recovery Manager (RMAN), you performed a closed database backup on Friday. The database is running in ARCHIVELOG mode. On Monday morning, you find that the media that contains the one of the data files is corrupted and you execute the following command to start the recovery process:
RMAN> RESTORE DATABASE;
Which files are restored because of this command? (Choose all that apply.)
A. the data files
B. the control file
C. the password file
D. the Server Parameter file (SPFILE)
Which two statements are true regarding the Recovery Manager (RMAN) CROSSCHECK command? (Choose two.)
A. It reports the statuses of the backups that are marked OBSOLETE.
B. It scans the complete RMAN repository and the contents of the backups to ensure that both
C. It provides metadata information about the backups that are not yet registered in the RMAN
D. It updates the metadata information of a backup to EXPIRED if the corresponding backup is
not found on the disk or media management catalog.
E. It ensures that the metadata of backups and image copies is synchronized with the actual backups
and image copies on the disk or media management catalog.
You are using Recovery Manager (RMAN) to back up your database at regular intervals. On Monday morning, you realize that the data file, users.dbf, is corrupted. You need to restore the data file to a different location from the current location of the data file, by using the RMAN back up of the data file. Which task must you accomplish after you execute the SET NEWNAME command to change the location of the data file?
A. resync the recovery catalog
B. resync the RMAN repository
C. use the operating system utility to create a copy of the data file in the new location
D. use the RMAN RESTORE command to create a copy of the data file in the new location
E. use the RMAN DUPLICATE command to create a copy of the data file in the new location
If you want to pass Oracle 1Z0-032 successfully, donot missing to read latest lead2pass Oracle 1Z0-032 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.