Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP (1z0-034) Free Practice Test

Question 1

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead

B. The number of ASMB processes increases

C. The number of DBWR_TO_SLAVES increases

D. The number of DBWR processes increases

Correct Answer: A

Question 2

Identify three key features of Oracle Data Pump (Choose three.)

A. Data Pump can perform import using database link

B. Data Pump can stop a running job and resume it later

C. Data Pump can perform incremental and cumulative exports

D. Data Pump uses absolute path instead of relative path

E. Data Pump uses relative path instead of absolute path

Correct Answer: A,B,E

Question 3

Identify two advantages of using a recovery catalog instead of the control file of the target database in Recovery Manager (RMAN).

A. Recovery is faster if data is stored in catalog in addition to the control file.

B. Database backups are automatically deleted when they are older than the specified time period.

C. You can store backup information of all registered databases in one place.

D. You can use RMAN stored scripts.

Correct Answer: C,D

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

Question 4

Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

A. New name for the data files of the tablespace

B. Auxiliary name for the data files of the tablespace

C. New channels for restore and recovery tasks

D. Auxiliary destinations for an auxiliary set of data files

Correct Answer: D

Question 5

You observed the following output for a user session:

What do you infer from the preceding output?

A. Resumable set for session with sid 18

B. The database instance is enabled to use asynchronous commit

C. The user session has entered into a deadlock

D. The threshold warning limit is exceeded for the tablespace that is used by the user session

Correct Answer: A

Question 6

You want to create a consumer group, GROUP1, and you execute the following command
in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP (CONSUMER_GROUP
=>'group1', COMMENT => 'New Group'); This command errors out displaying the following message: ERROR at line 1: ORA-29371: pending area is not active ORA-06512: at "SYS.DBMS_RMIN", line 115 ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108 ORA-06512: at line 1 What action would you take to overcome this error?

A. increase the size of the database buffer cache to accommodate the Pending Area

B. create the Pending Area before creating the consumer group

C. increase the size of the large pool to accommodate the Pending Area

D. increase the size of the shared pool to accommodate the Pending Area

E. activate the Pending Area before creating the consumer group

Correct Answer: B

Question 7

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. Automatic checkpoint tuning will be enabled.

C. The MTTR advisor will be disabled.

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.

Correct Answer: A,B

Question 8

You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.
What must you set using the RMAN CONFIGURE command to achieve this?

A. RETENTION POLICY TO REDUNDANCY 2;

B. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

C. DEVICE TYPE DISK PARALLELISM 2;

D. MAXSETSIZE TO 2;

Correct Answer: B

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

Welcome to TestSimulate

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP (1z0-034) Free Practice Test