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?
    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.)
    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?
    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?
    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?
    Correct Answer: A, D