Oracle 1z0-070 問題集

質問 1：
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 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.
C. 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.
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. 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.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true about Exadata X5 cell metrics and alerts?
A. Cell metrics on each storage server are accumulated in memory by the CELLSRV process and written to a filesystem-based repository.
B. Cell alerts on each storage server are accumulated in memory by the CELLSRV process and stored on a filesystem-based repository.
C. Cell metrics are written to disk every hour by default.
D. Cell alerts on each server are accumulated in memory by the MS process and stored on a filesystem-based repository.
E. Cell alerts are written to disk every hour by default.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Your Exadata X6-2 Database Machine has the exachk utility preinstalled. You decide to use it periodically to validate the installation against Oracle's recommended best practices.
Which three actions could you take to do this?
A. Use exachk to schedule itself to run at regular intervals.
B. Create a OS job in Enterprise Manager to run the exachk utility at regular intervals.
C. Use a cron job on a database node to run it at regular intervals.
D. Run it once each cell and it will then perform periodic monitoring automatically.
E. Use a cron job on each cell to run it at regular intervals.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three are true concerning Hybrid Columnar Compression (HCC) deployed on Exadata storage?
A. Row-level locks are supported on HCC compressed data.
B. By default, decompression is performed by Exadata Storage Servers.
C. HCC can be used only when the Exadata Smart Flash Cache is configured in Write-Through mode.
D. HCC data is never cached in the Exadata Smart Flash Cache.
E. Rows residing in HCC compressed segments, are always self- contained in a single compression unit.
F. Rows residing in HCC compressed segments, are always self- contained in a single database block.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two must be true for a Smart Scan to occur on a table?
A. It must be stored in an ASM diskgroup with a 4 MByte AU size.
B. It must be heap organized.
C. Sessions querying the table must set cell_offload_processing = true.
D. It must be accessed using direct path reads.
E. The table must not be compressed.
正解：C,D

質問 6：
Which two options should be used to identify a damaged or failing flash card on an X6 Database Machine high-capacity storage server?
A. Using the CELLCLI CALIBRATE command on the storage server after logging in as the celladmin user
B. Using the CELLCLI CALIBRATE command on the storage server after logging in as the root user
C. Using the CELLCLI LIST LUN DETAIL command as the celladmin user
D. Hardware monitoring using the storage server ILOM
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which three statements are true concerning the configuration of SNMP on an Exadata x5 or x6 Database Machine?
A. The Database Machine internal Cisco Switch communicates directly with the Enterprise Manager agent via SNMP.
B. All SNMP notifications from the storage server ILOMs are sent directly to the Automatic Service Request (ASR) manager.
C. All SNMP notifications from a database server ILOM are sent directly to the Automatic Service Request (ASR) manager.
D. Some SNMP notifications may be configured using the alter cell command on the storage servers.
E. All SNMP notifications from a database server ILOM are sent directly to the management server (MS) process on the same database server.
F. Some SNMP notifications from a storage server ILOM are sent directly to the management server (MS) process on the same storage servers.
正解：C,D,F
解説: (Topexam メンバーにのみ表示されます)