1Z0-070 Oracle Oracle Exadata X5 Administration
QUESTION: 82 In which three situations will a Smart Scan occur on a table for which Smart Scan is possible, assuming that nothing in the environment prevents a Smart Scan? A. The ASM diskgroup containing the table’s tablespace has a 4 MByte AU size. B. Executing queries in parallel. C. setting serial_direct_read= true in the session issuing the SQL statements and executing a serial query. D. Having direct path reads used at execution time. E. An update to the table is made identifying the row to be modified by primary key. F. An index range scan occurs for the table. Answer: B, C, D Explanation: Whether you get a direct path read & smart scan, depends on the current buffer cache size, how big segment you’re about to scan and how much of that segment is actually cached at the moment. This dynamic decision unfortunately can cause unexpected surprises and variance in your report/batch job runtimes. To work around these problems and force a direct path read/smart scan, you can either: D: One of the most common Exadata performance problems is that the direct path reads (and thus also Smart Scans) don’t sometimes kick in when running full scans in serial sessions. Note: Smart Scan is a subset of Cell Offload Processing and is perhaps the feature that is most highly associated with Exadata. Smart Scan allows Oracle databases to push query information down to the storage level, specifically: QUESTION: 83 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 any database server. B. The Infiniband subnet master location can be determined by using the getmaster command run on an IB switch. C. The InfiniBand port status may be displayed on the storage servers by using the LIST IBPORT command in the CELLCLI utility. D. The InfiniBand port status may be displayed on the Infiniband switches by using the LIST IBPORT command in the DBMCLI utility. E. The InfiniBand port status may be displayed on the database servers by using the LIST IBPORT command in the DBMCLI utility.