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

You are evaluating the performance of a SQL statement that accesses a very large table.
You run this query:

Identify two reasons why the "cell physical IO interconnect bytes" statistic is greater than the "cell physical IO interconnect bytes returned by smart scan" statistic.

• A.There is a local index on a list partitioned table on the column used in the WHERE clause, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• B.There are chained rows in the table, causing some "cell single block physical reads" to be requested by the database instance, resulting in additional I/O.
• C.The table is list partitioned, causing "cell list of blocks physical reads" to be requested by the database instance, resulting in additional I/O.
• D.There is a transaction, which committed after the query began, 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.
• E.The table is a hash clustered table, causing "cell multiblock physical reads" to be requested by the database instance, resulting in additional I/O.

Which two network switch failure scenarios on a standalone Exadata Database Machine X5-2 Full Rack will affect database availability?

• A.failure of both the InfiniBand leaf switches
• B.failure of a single InfiniBand leaf switch and the Ethernet switch
• C.failure of both the InfiniBand leaf switches and the Ethernet switch
• D.failure of a single InfiniBand leaf switch
• E.failure of the Ethernet switch only

Which statement is true about operating systems in an X5 Database Machine multirack configuration consisting of two full racks and one Exadata storage expansion rack?

• A.All Exadata storage servers used by the same virtual cluster nodes must run the same O/S but Exadata Storage Servers in different clusters may run different operating systems.
• B.All Exadata storage servers must run Oracle Linux.
• C.All Exadata storage servers may run Oracle Virtual Machine (OVM).
• D.All Exadata storage servers must run the Oracle Linux O/S and all database servers within the same cluster must run the same version of Oracle Virtual Machine (OVM).
• E.All Exadata storage servers must run the Oracle Solaris O/S and all database servers within the same cluster must run Oracle Linux.

Which three are true concerning Smart Scans?

• A.Smart Scans are possible on heap organized tables.
• B.Smart Scans are possible on uncompressed B*Tree indexes.
• C.Smart Scans always outperform scans that are not offloaded.
• D.Smart Scans are only possible during full table scans or fast full index scans.
• E.The decision to perform a Smart Scan is made by the Optimizer.
• F.Smart Scans are possible on Index Organized Tables (IOTs).

Batch and DSS workloads on your Exadata X6 Database Machine are causing performance problems for OLTP workloads at certain times of the day.
There are five RAC databases performing OLTP I/O. Two of them also perform batch I/O. There is another RAC database that performs only DSS I/O.
You are asked to resolve this problem so that the OLTP workload will not suffer when competing with the batch or DSS workloads.
You decide to use the I/O resource manager.
Which is the best way to solve this problem?

• A.Use the Database Resource Manager to give the OLTP category the highest priority and use EXADCLI calling EXACLI to create the OLTP category on all the cells.
• B.Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to create the OLTP category and map all OLTP- oriented consumer groups in all databases to it.
• C.Create a category plan with EXADCLI calling EXACLI to give the OLTP category the highest priority on all the cells, and use the Database Resource Manager to give the OLTP consumer group the highest priority on all databases.
• D.Create a database plan using EXADCLI calling EXACLI to give OLTP I/O the highest priority from all six databases.