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 #1

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

A. PGA_AGGREGATE_TARGET

B. SORT_AREA_SIZE

C. BITMAP_MERGE_AREA_SIZE

D. HASH_AREA_SIZE

E. CREATE_BITMAP_AREA_SIZE

Discussion 0

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

Question #2

You created a database with the Database Configuration Assistant (DBCA) by using one of the default templates.
Which tablespace will be the default permanent tablespace for non-system users, excluding DBSNMP and OUTLN?

A. SYSAUX

B. SAMPLE

C. USERS

D. EXAMPLE

E. SYSTEM

Discussion 0

Correct Answer: C Vote an answer

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

Question #3

Which two statements are true about the duplexing of the backups taken by RMAN?

A. Duplex backups need a parallelism for the device to be equal to number of copies

B. It's only supported for the backups performed on the tape

C. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

D. It is not supported for backup operations that produce image copies

Discussion 0

Correct Answer: C,D Vote an answer

Question #4

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

A. Traditional partition pruning and partitionwise joins are not supported on these tables.

B. The same physical attributes must be specified for each partition.

C. Unique local indexes cannot be created on a system-partitioned table.

D. All DML statements must use partition-extended syntax.

E. Only a single partitioning key column can be specified.

Discussion 0

Correct Answer: A,C Vote an answer

Question #5

You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)

A. It is a default bigfile tablespace.

B. It is a dictionary-managed tablespace.

C. It is a bigfile tablespace (BFT).

D. It is a smallfile tablespace.

E. It is a locally managed tablespace.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #6

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

A. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.

B. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.

C. The MTTR advisor will be disabled.

D. Automatic checkpoint tuning will be enabled.

Discussion 0

Correct Answer: A,D Vote an answer

Question #7

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

B. An ASM instance mounts an ASM control file

C. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Discussion 0

Correct Answer: A,D Vote an answer

Question #8

Which two statements are correct about database transportation? (Choose two.)

A. The source and target platforms must be the same

B. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

C. Redo logs, control files and temp files are also transported

D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

Discussion 0

Correct Answer: D,E Vote an answer

Question #9

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.
S expdp system/manager Schemas =hr,oe directory =EXP_ DIR include = table
$ impdp system/manager Schemas = hr1,oe1 Directory = EXP_DIR Dumpfile = export.dat Remap_schema =hr:hr1,oe :oe1
What would be achieved by running the above commands?

A. impdp will create two users called hrl and oe1 and import all objects to the new schemas

B. expdp will fail because no path has been defined for the dumpfile.

C. impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.

D. expdp will succeed but Impdp will fail because users do not exist.

Discussion 0

Correct Answer: D Vote an answer

Question #10

Which two statements are true regarding hot patching? (Choose two.)

A. It is available for installing all patches on all platforms.

B. It does not require database instance shutdown.

C. It requires relinking of the Oracle binary.

D. It works only in a single database instance environment.

E. It can detect conflicts between two online patches.

Discussion 0

Correct Answer: B,E Vote an answer

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

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.