Master the 1z0-034 Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP content and be ready for exam day success quickly with this Pass4sure 1z0-034 test engine. We guarantee it!We make it a reality and give you real 1z0-034 questions in our Oracle 1z0-034 braindumps.Latest 100% VALID Oracle 1z0-034 Exam Questions Dumps at below page. You can use our Oracle 1z0-034 braindumps and pass your exam.

♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1z0-034 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1z0-034 Exam Dumps (PDF & VCE):
Available on:

Q1. 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. Multiple change tracking files can be created for a database. 

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

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

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

Answer: C,D 

Q2. View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN session: 


The database has seven data files. Why is the value of %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77? 

A. Because the progress is reported for each data file 

B. Because the progress is reported for each backup set 

C. Because other RMAN sessions have issued the same BACKUP command 

D. Because new data files have been added to the database while the RMAN backup is in progress 


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

A. An ASM instance mounts an ASM control file 

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

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

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

Answer: C,D 

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

A. The MTTR advisor will be disabled. 

B. Automatic checkpoint tuning will be enabled. 

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

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

Answer: B,C 

Q5. Examine the following command for RMAN backup: 











Which statement is true regarding the approach in the command? 

A. The RMAN multiplexing level is 4. 

B. It is the use of asynchronous I/O by RMAN. 

C. It is a case of parallelization of the backup set. 

D. It is an implementation of a multi section backup. 


Q6. 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? 

A. Control files 

B. Password file 

C. Inactive online redo log file 

D. Archived log files required to perform recovery 

E. Newly created tablespace which is not backed up 

Answer: A,D 

The RESETLOGS options is required in: 

1. Imcomplete Recovery 

2. Change of control file 

So that, the control file and archived redo logs are required. 

Q7. Your database is open and running in ARCHIVELOG mode. 

You take RMAN full backups every Sunday night. 

On Monday morning, while querying the user1.emoloyees table, you receive the following error message: 

01578: ORACLE data block corrupted (file # 5, block # 51) ORA-0lll0: data file 5: '/u01/app/oracle/oradata/orcl/exanple0l.dbf* 

You need to recover from this while ensuring that: 

1. The data file remains online. 

2. Mean Time To Recover (MTTR) is minimized as much as possible 

You have no backup control file, but all the archived logs are accessible. Which method will best satisfy the requirements? 

A. flash back the corrupted blocks 

B. use the DBMS_REPAIR package 

C. use RMAN tablespace point in time recovery 

D. use the RMAN BLCCKRECOVER command 

E. perform a table point in time recovery with datapump export and import 


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


A. 2, 4, and 5 

B. All the steps 

C. 2, 3, 4 and 5 

D. 1, 2, 4, 5 and 6 


Refer to here. Generate a Transportable Tablespace Set read_only--expdp--4-import-read_wrtie 

1, 2, 4, 5, 6 (optional) 

If both platforms have the same endianness, no conversion is necessary. Otherwise you must do 

aconversion of the tablespace set either at the source or destination database. 

Transport the dump file to the directory pointed to by the DATA_PUMP_DIR directory object, or to 

any otherdirectory of your choosing. 

Run the following query to determine the location of DATA_PUMP_DIR: 


Transport the data files to the location of the existing data files of the destination database. On the UNIX and Linux platforms, this location is typically /u01/app/oracle/oradata/SID/ or +DISKGROUP/SID/datafile/. 

Q9. After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database? 

A. Opening the database in RESTRICTED mode 

B. Opening the database with the RESETLOGS option 

C. Setting a new DBID for the newly restored database 

D. Restoring the server parameter file (SPFILE) to the new host 


Q10. Which two statements are true about a job chain? (Choose two.) 

A. A job chain can contain a nested chain of jobs. 

B. The jobs in a job chain cannot have more than one dependency. 

C. A job of the CHAIN type can be run using event-based or time-based schedules. 

D. The jobs in a job chain can be executed only by using the events generated by the Scheduler 

Answer: A,C 

Defining Chain Steps After creating a chain object, you define one or more chain steps. Each step can point to one of the following: 

You define a step that points to a program or nested chain by using the DEFINE_CHAIN_STEP procedure. An example is the following, which adds two steps tomy_chain1: