Oracle 1Z0-902 問題集

質問 1：
I/O performance of the prod database on your Exadata Database Machine has degraded slightly over the past month. The database has been allocated to the OLTP I/O Resource Management (IORM) category.
Which two monitoring tools might be useful in examining I/O performance for the prod database?
A. OS I/O metrics using OS tools such as iostat on the storage servers
B. I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us
C. cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk
D. OS I/O metrics using OS tools such as iostat on the database servers
E. OS I/O metrics using Enterprise Manager host pages for the storage servers
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have been asked to design a backup solution for an Exadata X9M-2 Quarter Rack with Extreme Flash Storage Servers connected to a new ZFS Storage Appliance ZS7 with 2 Storage Controllers with 100Gb Ethernet cards and 3 Storage Trays. You are using Oracle Exadata Configuration Assistant to validate the rack layout.
1. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU10.
2. Use drop down to add ZFS Storage Appliance Controllers.
3. You cannot add ZFS Storage Appliance to an Exadata Rack.
4. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU1.
5. Use drop down to add ZFS Storage Trays.
6. Use "Add Equipment" to add the Exadata X9M Database Servers, starting from RU16.
7. Use "Add Equipment" to add the Exadata X9M EF Storage Servers, starting from RU1.
8. Use drop down to add Exadata X9M EF Storage Servers.
9. Use "Add Equipment" to add the ZFS Storage Controllers, starting from RU27.
10. Use drop down to add Exadata X9M Database Servers.
11. Use "Add Equipment" to add the ZFS Storage Trays, starting from RU31.
Which of these steps are correct and what is their correct order?
A. 10, 8, 9, 11
B. 3
C. 10, 8, 2, 5
D. 4,1, 6, 9
E. 7,6,9,11
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements are true about applying updates on Exadata systems?
A. To speed up applying storage server updates in a rolling manner, updating two storage servers simultaneously is recommended.
B. Updating kernel and RDMA packages on storage cells should be prevented by excluding them with the yum -exclude option.
C. Failed database server updates are rolled back to a working state on a previous release automatically.
D. Failed storage server updates are automatically rolled back to a previous release.
E. For regular Exadata updates, yum automatically installs a non-UEK kernel, which can be selected to boot from grub.
F. When running a "yum update" for a new Exadata release, all other repositories should be disabled.
正解：D,F
解説: (Topexam メンバーにのみ表示されます)

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

質問 5：
Assume that the RDBMS and ASM instances are up and you are enabling write-back flash cache in one cell server at a time.
Which step(s) should you perform before executing the following command you your Exadata X9M-8 Database Machine, which will set the cell flash cache mode to write-back?
#cellcli -e alter cell flashCacheMode=WriteBack
A. Drop the existing flash cache on the cell.
B. Shut down the CELL5RV service on the cell.
C. Inactivate the grid disks on the cell.
D. Create a new flash cache on the cell.
E. Inactivate all the physical disks on the cell.
F. Disable the storage indexes on the cell.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You are working on a remote Exadata Database Machine with current software and firmware. You now need to start a storage server after hardware maintenance.
Which ILOM command starts the storage server?
A. -> start /SYS/power
B. You must be physically present in the data center to start an Exadata Storage Server.
C. -> start /SYSTEM/power
D. -> start /System
E. -> start /SP/console
F. -> set /SYS power_state=ON
正解：F
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which are two correct statements for managing virtual deployment using Oracle Exadata Deployment Assistant (OEDA)?
A. OEDA allows customers to have both bare metal (BM) and virtual machine (VM) in an Exadata X9M Quarter Rack.
B. OEDA sets up key-based authentication for the root user by using the setuprootssh.sh utility included with OEDA.
C. There is no limit on the number of VMs in an Exadata rack as long as the Exadata rack has adequate resources.
D. OEDA deployment steps include calibrate cells, create cell disks, and resecure machine.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 8：
What is the maximum DRAM capacity you can expand an X9M-2 DB Server?
A. 768GB
B. 1024GB
C. 512GB
D. 1536GB
E. 2048GB
F. 384GB
正解：D
解説: (Topexam メンバーにのみ表示されます)