1z0-070 試験問題を無料オンラインアクセス

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 17b
Port 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 Gbps
LinkState: ......................Active
PhysLinkState: ................LinkUp
LinkSpeedActive: ..............10.0 Gbps
LinkSpeedEnabled: .............2.5 Gbps or 5.0 Gbps or 10.0 Gbps
You have 36 ports to check.
Which two methods would you use to check the status of all 36 ports?

• A.Create user-defined metrics for the InfiniBand switch.
• B.Use the ibqueryerrors.pl script after logging in to the InfiniBand switch as root.
• C.Use Enterprise Manager Express.
• D.Use Enterprise Manager.Cloud Control.

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.Fail over to any secondary agent is done automatically.
• B.Fail back to the original agent when the host is restarted is done automatically.
• C.Fail back to the original agent when the host is restarted must be done manually.
• 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.Database Machine plug-ins must be deployed to at least two Enterprise Manager agents.

Which two are benefits of an active/inactive configured InfiniBand network on Exadata Database Machine X5?

• A.Improved reliability when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
• B.Improved reliability for Cache Fusion RAC network traffic
• C.Improved performance when executing Distributed Command Line Interface (DCLI) to run CELLCLI commands
• D.Improved performance for ASM rebalance network traffic
• E.Improved performance for Oracle Network traffic

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.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.
• C.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.
• D.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.
• E.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.

Your X6 Exadata Database Machine is running Oracle Database 12c, and has a large database with some very large tables supporting OLTP workloads.
High-volume insert applications and high-volume update workloads access the same tables.
You wish to compress these tables without causing unacceptable performance overheads to the OLTP workload.
Which three are true regarding this requirement?

• A.Using row store compress advanced will compress the data less than if using column store compress for query low.
• B.Compression is performed on Exadata Storage Servers when using row store compress advanced in an Exadata environment.
• C.The compression method column store compress for archive high is the worst fit for this requirement.
• D.Compression is performed on database servers when using row store compress advanced in an Exadata environment.
• E.Using row store compress advanced will compress the data more than if using column store compress for archive low.