1z1-034 by Oracle Valid Free Exam Practice Test

Question 1

Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; }
Which statement is true about the duplicate database in this scenario?

A. It contains all data from only the committed transactions in the target database B. It contains data till the last backup C. It contains all data except that which is used by the transactions in the current online redo file of target database D. It contains all data from target database until the current time

Correct Answer: C

Question 2

Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace. A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error. B. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles. C. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database. D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Correct Answer: A

Question 3

You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?

A. A target database is registered in the recovery catalog B. The recovery catalog is empty C. The base recovery catalog must be dropped D. A base catalog exists

Correct Answer: D

Question 4

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?

A. Setting a new DBID for the newly restored database B. Opening the database with the RESETLOGS option C. Opening the database in RESTRICTED mode D. Restoring the server parameter file (SPFILE) to the new host

Correct Answer: B

Question 5

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 RECOVERY_PARALLELISM parameter to twice the number of CPUs B. using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area C. using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area. D. setting the FAST_START_MTTR_TARGET to set the mean time to recover

Correct Answer: B,C

Question 6

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.
What would you suggest to analyze this performance problem for the user?

A. Active Session History report B. SQL Performance Analyzer C. SQL Tuning Advisor D. AWR Compare Periods report

Correct Answer: A

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034 Exam Practice Test