Oracle 1Z0-070 PDF Study Material

Question No. 1

Identify the four software components that run only on an Exadata Database Machine Database Server.

• A. Cell Serve (CELLSRV)
• B. DISKMON
• C. CELLCLI
• D. Oracle Enterprise Manager Agent (OMA)
• E. Automatic Diagnostic Repository Command Interpreter (ADRCI)
• F. ASM instance
• G. DSKM

Question No. 2

You must apply patches and patch bundles in a rolling fashion, if possible, on the components of your Exadata X6 Database Machine.

You use RAC for your databases and also use Data Guard, having standby databases on another Database Machine.

You want to have scripts that contain the appropriate commands to patch your environment.

Your patch bundle is one the first database server and is located at /uo1/stage.

You have downloaded the oplan utility to the first database server and run:

$ORACLE_HOME/oplan/oplan generateApplySteps /u01/stage

Which two statements are true concerning the type of instructions oplan will generate?

• A. Instructions for patching the Grid Infrastructure home on the primary location
• B. Instructions for patching the Data Guard environment on the standby location
• C. Instructions for patching the RAC Oracle Home on the primary location
• D. Instructions for patching only storage servers
• E. Instructions for patching all components on the Database Machine

Question No. 3

You are planning your deployment of Enterprise Manager to monitor all the components of an X5 Database Machine.

A part of the requirement is to provide for high availability of the monitoring infrastructure.

If the host running the agent that has Database Machine targets bound to it fails, the monitoring of these targets must be done by another agent.

Which three statements are true regarding the configuration used to support this requirement?

• A. Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.
• B. Fail back to the original agent when the host is restarted is done automatically.
• C. Fail over to any secondary agent is done automatically.
• D. Fail over to any secondary agent must be done manually.
• E. Database machine plug-ins must be deployed to all Enterprise Manager agents.
• F. Fail back to the original agent when the host is restarted must be done manually.

Question No. 4

You are patching your Exadata X6 Database Machine by applying a new image to the Storage Servers in a rolling fashion.

Your ASM environment on the Database Machine has five diskgroups stored on an unpartitioned Exadata storage grid, with redundancy settings as shown:

1. DATA_DBM1 -- Normal Redundancy

2. RECO_DBM1 -- Normal Redundancy

3. DBFS_DG -- Normal Redundancy

4. DATA2_DBM1 -- High Redundancy

5. DATA3_DBM1 High Redundancy

Which two diskgroups will not suffer from any data loss throughout the patching process even if there is a single disk failure on one of the cells

• A. DBFS_DG
• B. DATA3_DBM1
• C. DATA2_DBM1
• D. DATA_DBM1
• E. RECO_DBM1

Question No. 5

Which two activities are supported on the storage servers in an Exadata X6 Database Machine?

• A. Upgrading the Storage Server software package using RPM
• B. Configuring secure shell user equivalency for the cellmonitor user
• C. Installing an alternative package manager
• D. Changing the root password
• E. Upgrading a device driver for hard disks when inserting a replacement disk after a hard disk failure

Question No. 6

An important application has been migrated to a database on an X5 Database Machine.

You are examining high-load SQL statements from this application, in an attempt to determine which ones will benefit from the Exadata Smart Scan capability.

Which three access paths always generate 'cell single block physical read' or 'cell multiblock physical read' requests?

• A. Index fast full scans executed in parallel
• B. Full table scans on heap organized tables executed in parallel
• C. Full table scans on heap organized tables executed serially
• D. Full table scans on index organized tables executed in parallel
• E. Index unique scan access by primary key to heap organized tables executed in parallel
• F. Index unique scan access by primary key to heap organized tables executed serially

Question No. 7

You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:

alter iormplan objective = low_latency

alter iormplan active

There are no database or category plans defined.

You are encountering disk I/O performance problems at certain times, which vary by day and week.

DSS and Batch workloads perform well some of the time.

Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.

You wish to have disk I/O managed so that performance will be optimized for all workloads.

Which statements would you issue to all Exadata Storage Servers to achieve this?

• A. alter iormplan objective=high_throughput
• B. alter iormplan objective=balanced
• C. alter iormplan objective=low_latency
• D. alter iormplan objective=auto
• E. alter iormplan objective=' '

Question No. 8

Which three statements are true about bulk data loading capabilities in an X5 Database Machine environment?

• A. DBFS must use the DBFS_DG diskgroup for any DBFS store.
• B. DBFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• C. DBFS must be used to have a POSIX-compliant shared storage solution that is accessible from the database servers on a Database Machine.
• D. DBFS must be used to bulk load data into a production database on the Database Machine.
• E. ACFS may be used if Exadata-based shared storage is required to stage data before bulk loading into a database.
• F. ACFS must be used to have a POSIX--compliant shared storage solution that is accessible from the database servers on a Database Machine.
• G. ACFS may use the DBFS_DG diskgroup to contain the ADVM volume file.