Oracle 1Z0-902 問題集

質問 1：
You plan to monitor the status of the motherboard, memory, power, fans, and network cards on the database nodes in your Exadata Database Machine using Enterprise Manager.
Where must you set the thresholds for these hardware components and why, to assure that sensor readings, faults, and any related alerts, are visible in Enterprise Manager?
A. Set thresholds in ILOM and in Enterprise Manager because they are not preset anywhere and must be set in both places.
B. No thresholds need to be set because they are preset in the ILOM and these are sufficient for monitoring.
C. Set thresholds only in ILOM because they are not preset anywhere but need to be set only in ILOM.
D. No thresholds need to be set because they are preset in the ILOM and in Enterprise Manager
正解：D

質問 2：
You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers.
The new storage servers are called DM01CEL08 through dmoicel14.
After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?
A. 7 consisting of 12 griddisks each
B. 0 because the new griddisks will be added to the existing faiigroups
C. 1 consisting of all 96 griddisks
D. 12 consisting of seven griddisks each
E. 96 consisting of one griddisk each
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
What are two recommended configuration best practices for backup and recovery on Exadata?
A. When off-site long-term backup retention is needed, use Oracle Database Backup Cloud Service as a low-cost, offsite scalable storage for a disaster recovery solution.
B. The internal Recovery Appliance backup and restore processing is optimized when the RMAN FILESPERSET parameter is set to 1 for the level 1 incremental backup set.
C. Even if the backup was limited to writing to four tape drives, eight channels could be specified to expedite the restore process.
D. Placing the backup network on dedicated switches installed in the top of the rack (ToR) has the benefits of isolating the backup network from other workloads and providing a greater level of control.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two sections of the AWR report shows statistics for X9M Persistent Memory Cache?
A. PMEM Pool cache Read Hits in the Cache Sizes portion of the Report Summary
B. PMEM Cache section within Memory Statistics
C. cell PMEM cache Read Hits in the Database IOs portion of the Performance Summary
D. PMEM Cache section within Exadata Smart Statistics
E. PMEM Pool Misses in the Exadata Outlier Summary
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You must drop all celldisks on all the storage servers in an X9M-2 quarter rack as part of a reconfiguration project.
Which three statements describe the account on the storage servers which you should use and the tool that may be used to drop the celldisks?
A. to the CELLMONITOR account using cellcli interactively on each storage server
B. to the CELLADMIN account using cellcli interactively on each storage server
C. to the CELLMONITOR account calling CELLCLI on all cells using DCLI
D. to the CELLADMIN account by calling CELLCLI on all cells using DCLI
E. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling CELLCLI on all cells using exadcli
F. to an administrator-created storage server user with appropriate privileges on celldisk objects by calling EXACLI on all cells using exadcli
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about Oracle Configuration Manager (OCM) for an Exadata Database Machine?
A. It is mandatory to install OCM on at least one database server.
B. Collected configuration information can be uploaded manually to Oracle.
C. It collects configuration information on demand.
D. It is mandatory to install OCM on all database servers.
E. It collects configuration information automatically.
F. Collected configuration information can be uploaded automatically to Oracle.
正解：C,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true about Exadata System Software metrics and alerts on an Exadata Database Machine?
A. Metric alert notifications can be sent to only one destination such as Enterprise Manager OR SNMP OR SMTP.
B. SMTP metric alert notifications must be sent to both ASR manager and Enterprise Manager agents.
C. Metric alerts are never stateful.
D. Metrics have no thresholds set on them by default.
E. Metric thresholds, if set, will persist across storage and database server reboots.
正解：D,E
解説: (Topexam メンバーにのみ表示されます)

質問 8：
Which three statements are true about the CELLCLI command?
A. It requires root privileges to create CELLDISKS and GRIDDISKS.
B. It has command-line history.
C. It can be executed using the DCLI utility.
D. It can be executed on storage servers.
E. It can execute commands on multiple storage servers in parallel.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)