Oracle 1z0-070 問題集

質問 1：
Which two communication methods are used by which components in the Enterprise Manager architecture for a Database Machine?
A. SNMP traps for alerts are sent by the storage server ILOM directly to the Enterprise Manager agent.
B. SNMP traps for alerts are sent by the storage server ILOM to the storage server RS process.
C. SNMP traps for alerts are sent by the storage server ILOM to the storage server MS process.
D. SNMP traps for alerts are sent by the storage server MS process to the Enterprise Manager agent.
E. SNMP traps for alerts are sent by the storage server MS process to the storage server ILOM.
正解：C,D

質問 2：
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 メンバーにのみ表示されます)

質問 3：
Examine this list of software components:
1. Oracle Virtual Machine (OVM)
2. Oracle Enterprise Manager Agent (OMA)
3. ASM instance
4. RDBMS instance
5. Automatic Diagnostic Repository Command Interpreter (ADRCI)
6. CELLCLI
7. Cell Server (CELLSRV)
8. diskmon
Identify the location where these software components can run in the standard Exadata Database Machine deployment.
A. 1, 2, 3, 4 and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
B. 1, 2, 3, 4, 5, and 8 run on the database servers; 5, 6, and 7 run on the Exadata storage servers.
C. 2, 3, 4 and 8 run on the database servers; 1, 5, 6 and 7 run on the Exadata storage servers.
D. 3, 4 and 8 run on the database servers; 1, 2, 5, 6 and 7 run on the Exadata storage servers.
E. 1, 2, 3 and 4 run on the database servers; 5, 6, 7, and 8 run on the Exadata storage servers.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You wish to determine if the I/O resource management plan that you created has helped improve the performance of OLTP category I/Os on your X6 Exadata Database Machine.
You decide to examine the relevant metrics on all the cells, to see whether the I/O rate has improved for this category compared to last week, and whether waits and wait time have been reduced.
You issue this command on the first cell:

You examine the output from the first cell which contains:

Which two sets of metrics would you use to determine whether the I/O performance has improved for the OLTP category for the duration of the one-hour measurement period?
A. CT_IO_RQ_SM, CT_IO_RQ_LG, CT_IO_RQ_SM_SEC, and CT_IO_RQ_LG_SEC
B. CT_IO_RQ_SM_SEC and CT_IO_RQ_LG_SEC
C. CT_IO_UTIL_SM and CT_IO_UTIL_LG
D. CT_IO_WT_SM, CT_IO_WT_LG, CT_IO_WT_SM_RQ, and CT_IO_WT_LG_RQ
正解：D

質問 5：
You issued these commands to all Exadata Storage Servers in an X6 Exadata Database Machine using dcli:
alter iormplan objective = low_latency
alter iormplan active
There are no database or category plans defined.
You are encountering disk I/O performance problems at certain times, which vary by day and week.
DSS and Batch workloads perform well some of the time.
Further investigation shows that at times, the workloads are all OLTP I/Os, at other times all batch I/Os, and sometimes a bit of each.
You wish to have disk I/O managed so that performance will be optimized for all workloads.
Which statements would you issue to all Exadata Storage Servers to achieve this?
A. alter iormplan objective=balanced
B. alter iormplan objective=low_latency
C. alter iormplan objective=high_throughput
D. alter iormplan objective=auto
E. alter iormplan objective=' '
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You plan to monitor the ASM configuration on an X5 Database Machine as part of your role supporting Exadata-based ASM diskgroups.
You want to check for potential space problems that take ASM mirroring requirements into account.
Which two values would you monitor from V$ASM_DISKGROUP or by using the ASMCMD LSDG command?
A. usable_file_mb
B. total_mb
C. free_mb
D. required_mirror_free_mb
E. cold_used_mb
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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. The rescue procedure must be used to recover from a failed Exadata storage server software upgrade.
C. An Exadata storage server automatically enters the rescue environment when it cannot boot from the system area.
D. The rescue procedure can be used to repair corruption in an ASM diskgroup.
E. The rescue procedure can be executed from the CELLBOOT USB flash drive.
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which three must be true for a Smart Scan to occur for a table?
A. The query must be executed in parallel.
B. The ASM diskgroup containing the table's tablespace must have a 4 Mbyte AU size.
C. Direct path reads must be used at run time.
D. cell_offload_processing must be true in sessions issuing SQL statements that access the table.
E. The ASM diskgroup containing the table's tablespace must have cell.smart_scan_capable set to true.
F. The query must be executed serially.
正解：C,D,E
解説: (Topexam メンバーにのみ表示されます)