Upgrade Oracle9i10g OCA to Oracle Database 11g OCP

Here you have the best Oracle 1z0-034 practice exam questions

You have 148 total questions to study from
Each page has 5 questions, making a total of 30 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 25, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 148

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

The MTTR advisor will be disabled.

Automatic checkpoint tuning will be enabled.

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

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

Correct Answer: B, C

Question 2 of 148

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.)

setting the FAST_START_MTTR_TARGET to set the mean time to recover

setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs

using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area

using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.

Correct Answer: C, D

Question 3 of 148

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?

Provide a password for the encryption.

Set up an Oracle wallet for the encryption.

No setup is required as it is a default encryption method.

Both Oracle wallet and password must be set up for the encryption.

Correct Answer: B

Question 4 of 148

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?

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

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

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

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

Correct Answer: B

Question 5 of 148

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

Control files

Password file

Inactive online redo log file

Archived log files required to perform recovery

Newly created tablespace which is not backed up

Correct Answer: A, D