Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

QUESTION NO: 1
In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching. B. It does not require down time to apply or remove unlike conventional patching. C. It takes more time to install or uninstall compared with conventional patching. D. It can be installed and uninstalled via OPatch unlike conventional patching. E. It is not persistent across instance startup and shutdown unlike conventional patching.

Correct Answer: A,B

QUESTION NO: 2
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:

A. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins. B. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. C. The COMMIT order in the captured workload is preserved during replay. D. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. E. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

Correct Answer: B,C,D

QUESTION NO: 3
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository.
Which condition must be met before you create the VPC?

A. A target database is registered in the recovery catalog B. The recovery catalog is empty C. The base recovery catalog must be dropped D. A base catalog exists

Correct Answer: D

QUESTION NO: 4
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 uses relative path instead of absolute path D. Data Pump can perform incremental and cumulative exports E. Data Pump uses absolute path instead of relative path

Correct Answer: A,B,C

QUESTION NO: 5
While designing a database, you created the EMPLOYEES table as an index-organized table (IOT).
You must create a bitmap index on the EMPLOYEES .JOB_ID column.
Which must you do to enable the creation of the bitmap index?

A. A mapping table must have been created. B. The PCTTHRESHOLD option must have been specified. C. A primary key must have been created. D. An overflow tablespace must have been specified.

Correct Answer: A

QUESTION NO: 6
You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?

A. You must put the database in NOARCHIVELOG mode to perform a block media recovery. B. You must ensure that the SALES database is mounted or open. C. You must restore a backup control file to perform a block media recovery. D. You must take the tools01.dbf data file offline before you start a block media recovery. E. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

Correct Answer: B,E

QUESTION NO: 7
You notice that the performance of the database has degraded because of frequent
checkpoints.
Which two actions resolve the issue?

A. Decrease the number of redo log members if there are more than one redo log members available in each redo log group. B. Check the size of the redo log file size and increase the size if it is small. C. Disable automatic checkpoint tuning. D. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

Correct Answer: B,D

QUESTION NO: 8
Which statement is true about a Scheduler-generated event?

A. It can be generated when a file arrives on the file system. B. it indicates state changes that occur within the Scheduler itself. C. it requires jobs to be defined with an event condition and a queue specification. D. it is raised by an application that is consumed by the Scheduler to start a job.

Correct Answer: C

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

QUESTION NO: 9
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

A. Database must be running in archivelog mode. B. Automatic undo management must be enabled. C. Flash recovery area must be defined D. Undo retention guarantee must be enabled. E. The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

Correct Answer: B,E

QUESTION NO: 10
View the Exhibit and examine the steps that you executed to create a database resource plan.
Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?

A. The OTHER_GROUPS resources consumer group is not included in the resource plan directive B. The procedure must be executed before creating the resources plan directive C. The SYS_GROUP resource consumer group is not included in the resource plan directive D. The pending area is automatically submitted after the plan creation

Correct Answer: A

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034 Exam Questions