1Z0-070 Online Practice Questions and Answers

Examine this list of software components:

1.

Oracle Virtual Machine (OVM)

2.

Oracle Enterprise Manager Agent (OMA)

3.

ASM instance

4.

RDBMS instance

5.

Automatic Diagnostic Repository Command Interpreter (ADRCI)

6.

CELLCLI

7.

Cell Server (CELLSRV)

8.

diskmon

Identify the location where these software components can run in the standard Exadata Database Machine deployment.

A. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.

B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

C. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.

D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.

E. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.

Which two statements are true about the use of DBFS, ACFS, and external file systems and components in an X5 Database Machine environment?

A. ACFS uses storage in a database on the database machine

B. DBFS supports file system snapshots.

C. ACFS supports file system snapshots.

D. Storage Area Network (SAN) –based file systems may be accessed directly from the storage servers in a database machine.

E. Oracle Sun ZFS Storage Appliance-based files are not automatically protected by Data Guard.

Which two are true about sparse griddisks and their use in disk groups on an X5 Exadata Database Machine?

A. Sparse diskgroups must be created using sparse griddisks.

B. Sparse diskgroups may be created using a combination of sparse and non-sparse griddisks.

C. Sparse diskgroups may not be used for database snapshots.

D. Additional space for a sparse griddisk is allocated as soon as newly written data is stored in the flashcache on a cell.

E. The virtual size of a sparse griddisk may exceed the physical size of the space occupied by the griddisk.

Which two statements are true about the Enterprise Manager plug-in configuration for the X5 Database Machine?

A. There is one plug-in for Cloud Control.

B. There are several separate plug-ins for Cloud Control.

C. Some components of the Database Machine require SNMP trap forwarders.

D. All components of the Database Machine require SNMP trap forwarders.

You are evaluating the performance of a SQL statement that accesses a very large table.

You run this query: Identify two reasons why the “physical read total bytes” statistic is greater than the “cell physical IO bytes eligible for predicate offload” statistic.

A. There is an index on the column used in the WHERE clause, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

B. The table is an IOT and has an overflow segment, causing “cell multiblock physical reads” to be requested by the database instance, resulting in additional I/O.

C. There is an uncommitted transaction that has modified some of the table blocks, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

D. The table is an index clustered table, causing “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

E. There are migrated rows in the table, causing some “cell single block physical reads” to be requested by the database instance, resulting in additional I/O.

You plan to migrate a database supporting an OLTP workload to your new X5 Database Machine.

The current database instance supports a large number of short duration sessions and a very high volume of short transactions.

Which three X5 Database Machine features can improve performance for this type of workload?

A. An improved highly efficient undo and redo architecture

B. Faster optimization due to an Exadata-specific optimizer

C. Reduced I/O latency for writes due to writeback flashcache on all Exadata X5 and later models

D. Ultra high I/O performance for reads and writes when using Exadata Extreme Flash in X5 and later models

E. Reduced I/O latency for reads due to read flashcache on all Exadata X5 and later models

You are checking the status of the ports on one of the InfiniBand switches on your X5 Database Machine.

You run the getportstatus command as shown:

[root@exampsw-ib2 bin]# getportstatus 17bPort status for connector 17B Switch Port 2 Adminstate:......................Enabled LinkWidthEnabled: ...............1X or 4X LinkWidthSupported:..............1X or 4X LinkWidthActive..................4X

LinkSpeedSupported: . ....2.5 Gbps or 5.0 Gbps or 10.0 GbpsLinkState: ....................Active PhysLinkState: ................LinkUpLinkSpeedActive: ...........10.0 GbpsLinkSpeedEnabled: .

...2.5 Gbps or 5.0 Gbps or 10.0 Gbps

You have 36 ports to check.

A. Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.

B. Use Enterprise Manager.Cloud Control.

C. Use Enterprise Manager Express.

D. Create user-defined metrics for the InfiniBand switch.

You want to use Enterprise Manager to monitor the power distribution units (PDUs) in your Database Machine.

On which three factors do the appropriate alarm thresholds for the plug-in depend?

A. voltage and phase type of the PDUs

B. disk types within the storage servers

C. Database Machine server models for both the storage servers and database servers in the rack

D. Database Machine rack size and variants

E. disk types within the expansion racks

F. distance between racks for multirack configurations

Which two statements are true about Database Server Metrics and Alerts on an X5 Database Machine?

A. Database Server Metrics are collected my MMON.

B. Database Server Metrics are collected by the MS process and stored in an internal disk-based repository.

C. Database Server hardware sensor alerts are detected by the MS process on the database server.

D. Database Server Metrics are collected by the RS process.

E. Database Server Threshold Alerts may be forwarded by the MS process as SNMP traps.

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