Oracle 1z0-034 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1z0-034
Exam Name/Title: Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Certification Provider: Oracle
Corresponding Certification: OCP

Exam Questions: 148
Updated On: Oct 05, 2026

Question #11

In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy.
Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?

A. using only the RMAN SWITCH command to set the new location for the data file

B. placing the database in the MOUNT state for the restore and recovery operations.

C. configuring two channels: one for the restore operation and the other for the recovery operation

D. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

Discussion 0

Correct Answer: D Vote an answer

Question #12

You notice that the performance of the database has degraded because of frequent
checkpoints.
Which two actions resolve the issue?

A. Disable automatic checkpoint tuning.

B. Check the size of the redo log file size and increase the size if it is small.

C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

Discussion 0

Correct Answer: B,C Vote an answer

Question #13

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

A. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

B. Multiple change tracking files can be created for a database.

C. RMAN does not support backup and recovery of the change tracking file.

D. The change tracking file must be created after the first level 0 backup.

Discussion 0

Correct Answer: A,C Vote an answer

Question #14

As part of archiving the historical data, you want to transfer data from one database to another database, whichis on another server. All tablespaces in the source database are read/write and online. The source and targetdatabases use the same compatibility level and character sets. View the Exhibit and examine the features inthe source and target database.
Which of the following steps are required to transport a tablespace from the database to the targetdatabase:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Convert data filed by using Recovery Manager (RMAN).
4.Transfer the dump file and data filed to the target machine.
5.Import metadata at the target database.
6.Make the tablespace read/write at the target database.
Exhibit:

A. 2, 3, 4 and 5

B. All the steps

C. 1, 2, 4, 5 and 6

D. 2, 4, and 5

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

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. SQL Performance Analyzer

B. SQL Tuning Advisor

C. AWR Compare Periods report

D. Active Session History report

Discussion 0

Correct Answer: D Vote an answer

Question #16

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 all data from target database until the current time

C. It contains data till the last backup

D. It contains all data except that which is used by the transactions in the current online redo file of target database

Discussion 0

Correct Answer: D Vote an answer

Question #17

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead

B. The number of ASMB processes increases

C. The number of DBWR_TO_SLAVES increases

D. The number of DBWR processes increases

Discussion 0

Correct Answer: A Vote an answer

Question #18

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

A. The time when the last flashback operation in your database was performed

B. The approximate time and the lowest system change number (SCN) to which you can flash back your database

C. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

D. The time when the first flashback operation in your database was performed

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #19

Which three statements are true about windows?

A. The database service name must be provided during windows creation

B. Windows can automatically start job or change resource allocation among jobs for various time periods.

C. Only one window can be open at any given time

D. Windows work with job classes to control resource allocation

E. Consumer groups are associated with windows

Discussion 0

Correct Answer: B,C,D Vote an answer

Question #20

Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?

A. the default permanent tablespace for the non-SYSTEM users

B. a read-only tablespace

C. a temporary tablespace

D. an undo tablespace

E. an offline tablespace

F. the SYSTEM tablespace

Discussion 0

Correct Answer: A,B,C,D Vote an answer

Download Free Oracle 1z0-034 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z0-034 exam.