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

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

Exam Questions: 148
Updated On: Sep 21, 2026

Question #1

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

A. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

B. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

C. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

D. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

E. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

Discussion 0

Correct Answer: C Vote an answer

Question #2

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:
1.Restore an autobackup of the server parameter file.
2.Restore the control file
3.Start the target database instance
4.Mount the database
5.Restore the data files
6.Open the database with RESETLOGS option
7.Recover the data files
8.Set DBID for the target database
Which option illustrates the correct sequence that you must use?

A. 1, 8, 3, 4, 2, 5, 7, 6

B. 1, 3, 4, 2, 8, 5, 6, 7

C. 8, 1, 3, 2, 4, 5, 7, 6

D. 1, 3, 2, 4, 6, 5, 7, 8

Discussion 0

Correct Answer: C Vote an answer

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

Question #3

You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?

A. They execute and create a virtual catalog for pre-Oracle 11g clients.

B. They produce an error because PROD1 and PROD2 databases belong to the older version.

C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.

D. They produce an error because you need to connect to the target database to execute this packaged procedure.

Discussion 0

Correct Answer: A Vote an answer

Question #4

Which three file types are managed by Data Pump jobs?

A. dump files

B. error files

C. SQL files

D. out files

E. alert files

F. log files

Discussion 0

Correct Answer: A,C,F Vote an answer

Question #5

You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.
From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?

A. Enterprise Manager is not used.

B. The TIMED_STATISTICS parameter is set to FALS

C. The SQL_TRACE parameter is set to FALSE.

D. The STATISTICS_LEVEL parameter is set to BASIC.

E. The EVEN parameter was not set.

Discussion 0

Correct Answer: D Vote an answer

Question #6

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?

A. Complete Recovery with archived redo log

B. Tablespace Point-in-Time Recovery (TSPITR)

C. Incomplete Recovery with system change number (SCN)

D. Complete Recovery with online redo log

Discussion 0

Correct Answer: B Vote an answer

Question #7

What two are the prerequisites for enabling Flashback Database?

A. The database instance must be started in the NOMOUNT state

B. The database instance must have the keep buffer pool defined

C. The database must be in ARCHIVELOG mode

D. The database must be opened in RESTRICTED mode

E. The database must be in MOUNT EXCLUSIVE mode

Discussion 0

Correct Answer: C,E Vote an answer

Question #8

memory_target big integer 808M
pga_aggregate_target big integer 0
sga_target big integer 0
SQL> SHOW PARAMETER SGA_MAX_SIZE
NAME TYPE VALUE
sga_max_size big integer 808M
Which statement is correct about the database?

A. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

C. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

D. SGA_TARGET are set.

E. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

Discussion 0

Correct Answer: A Vote an answer

Download Free Oracle 1z1-034 Demo

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