Oracle Database 19c: Performance Management and Tuning 試験対策問題集

模擬試験モードの設定

上記は本サイトの模擬試験モードの設定値です。実際の試験の出題数・制限時間・合格基準は、各認定プログラムの公式サイトでご確認ください。

出題分野

• Basic Tuning Methods and Diagnostics（手法と診断の基礎）（出題比率 11%）
• Statspack, Alert Log, and Trace Files（採取と記録の読み方）（出題比率 7%）
• Metrics, Alerts, Baselines, and AWR-Based Tools（指標と AWR）（出題比率 11%）
• Application Monitoring and Real Application Testing（監視と検証）（出題比率 7%）
• Identifying Problem SQL Statements（問題のある SQL の特定）（出題比率 11%）
• Optimizer Statistics and SQL Performance Management（統計と計画）（出題比率 15%）
• Reducing the Cost of SQL Operations（領域と索引の最適化）（出題比率 11%）
• Shared Pool, Buffer Cache, and In-Memory Store（SGA の調整）（出題比率 16%）
• Tuning the PGA and Automatic Memory Management（PGA と自動管理）（出題比率 11%）

フリー問題

1. A team wants a single number that expresses how much work the whole instance is …
2. Before touching any parameter, a performance engineer is told to write down what…
3. During an investigation a support engineer asks for the file that a single serve…
4. A site runs Oracle Database without a license for the management pack that conta…
5. A new administrator asks what the repository actually stores when a snapshot is …
6. The database maintains one baseline automatically, and an administrator can also…
7. A developer complains that a long report statement never appears in the real tim…
8. A nightly batch job runs dozens of statements across one session, and the team w…
9. An execution plan is displayed with both the estimated number of rows and the ac…
10. Two sessions submit text that is character for character identical. The first su…
11. A developer asks how the numbers held in the data dictionary about a table can p…
12. An interactive screen shows the first twenty rows of a long result and the users…
13. A database is about to be upgraded and the team wants to be protected from the p…
14. A shop rebuilds every index once a month in the belief that this keeps the extra…
15. A table has had many rows deleted over the years and full scans of it are still …
16. An application builds its statement text by pasting the search value straight in…
17. A query whose result is held in the server result cache is issued again after a …
18. A weekly report shows the buffer cache hit ratio at ninety four percent and the …
19. An administrator has set the aggregate target for private memory, and a batch wi…
20. A developer asks which part of memory holds the working data of a sort that a de…