A. Partition pruning allows you to reduce a 5 TB I/O operation to a much smaller I/O operation and therefore, enables a much faster return of information.

B. Using partition pruning can force the optimizer to use that method instead of Smart Scan.
Partitioning in Exadatashould be used wisely

C. Partition pruning allows you to reduce the size of the physical table by reducing fragmentation within the individual tables.

D. Partition pruning is not a supported option in the11gR2database codethatruns on an Exadata Machine, due to issues with Cost Based Optimizer plans.

E. Partition pruning allows you to reduce a 5 TB I/O operation to a larger I/O operation and therefore, forces the use of the Smart Scan technology.

A. EM Agents should not be installed on Exadata. Remote monitoring is the best practice.

B. The Exadata Plug-In for monitoring switches is installed in each EM Agent.

C. EM Agents can communicate to storage cells via SSH.

D. Storage cells communicate directly to the EM Management Server via SNMP and/or SMTP.

E. EM Agents are installed on each database and storage node.

A. Enable Smart Flash Log.

B. Enable Write Back Flash Cache.

C. Create an ASM diskgroup on Flash Cache and move the indexes from disk to Flash.

D. Execute alter table ... cell_flash_cache=keep on heavily scanned tables.

A. 2, 5, 1, 3, and 4

B. 5, 2, 4, 1, and 3

C. 5, 4, 2, 1, and 3

D. 2, 4, I, 3, and 5

A. configuring a Linux active-active channel bonding on the database servers by using two 10Gigabit Ethernet port

B. replacing the Ethernet switch with an equivalent 1U48-port Gigabit Ethernet switch

C. replacing the Sun Data Center InfiniBand Switch 36-spine switch with an InfiniBand Gateway Switch

D. installing a second Ethernet switch in the Exadata rack for client access network connectivity

E. configuring a Fibre Channel over Ethernet (FCoE) protocol on database servers

A. InfiniBand network cache

B. Hybrid Columnar Compression

C. Smart Flash Log

D. Exadata DRAM

E. high performance SAS disks

A. Ask application users if they have noticed a slowdown in screen response.

B. Look for an increase in batch job servicing times.

C. A & B above

D. Average the mpstat id1 output from all the nodes.

A. Evaluate the Smart Flash Logging efficiency metrics via CellCLI.

B. Check I/O latency on large I/O to Temp in AWR.

C. Compare Optimized Physical Reads and Total Read Requests in Automatic Workload Repository (AWR).

D. Review the IOSTAT data that is gathered from each compute node by OS Watcher.

E. Review the Flash Hit rate via cellcli metrics.