Online Access Free 1z1-070 Practice Test

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 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.
• 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 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.
• 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.

Which three statements are true concerning InfiniBand port and subnet monitoring on an X5 Database Machine?

• A.The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch.
• B.The Infiniband subnet master location can be determined by using the getmaster command run on any database server.
• C.The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.
• D.The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility.
• E.The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility.
• F.The InfiniBand port monitoring is automatic on the database servers and is managed by Enterprise Manager.

You plan to consolidate multiple mission-critical databases onto a single rack Exadata X6 Database Machine.
You do not plan to use virtualization on the database servers.
You have identified two database categories, based on differing availability and maintenance objectives.
Which two choices will be the best solution?

• A.Partition the Exadata storage servers into two separate storage grids.
• B.Create a single database cluster that accesses a single storage grid.
• C.Create a single storage grid and share space on the celldisks using Exadata storage realms.
• D.Create a single database cluster that accesses multiple storage grids.
• E.Partition the database servers into two separate clusters.

Which two statements are true about the X5 Exadata storage server rescue procedure?

• A.The rescue procedure can be used to restore a corrupt system area.
• B.An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
• C.The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.
• D.The rescue procedure can be executed from the CELLBOOT USB flash drive.
• E.The rescue procedure can be used to repair corruption in an ASM diskgroup.

You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = off
alter iormplan active
There are no database or category plans defined.
You are suffering I/O performance problems at certain times, which vary by day and week.
DSS and batch workloads perform well, but your OLTP workloads suffer poor response times when running at the same time as these other workloads.
You must ensure that DSS and batch workloads retain relatively high throughput without causing excessive degradation of OLTP performance.
Which statement would you issue to all Exadata Storage Servers to achieve this?

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