Oracle Database Administration II 試験対策問題集

模擬試験モードの設定

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

出題分野

• Creating and Managing CDBs and Regular PDBs（CDB と PDB の運用）（出題比率 12%）
• Application Containers and Multitenant Security（アプリと権限）（出題比率 13%）
• Backup, Recovery, Duplicate, and Flashback of PDBs（PDB の保護）（出題比率 6%）
• Backup Strategies and Configuring RMAN（バックアップ戦略と RMAN）（出題比率 13%）
• Restore, Recovery, and Diagnosing Failures（復旧の実行と診断）（出題比率 9%）
• Flashback, Duplicating a Database, and Transporting Data（出題比率 6%）
• Install, Patch, and Upgrade Grid Infrastructure and Database（出題比率 16%）
• Oracle Database 19c New Features（19c の新機能）（出題比率 9%）
• Monitoring, Tuning Performance, and Tuning SQL（性能と SQL の調整）（出題比率 16%）

フリー問題

1. A team is writing the CREATE DATABASE statement for a new database that will hos…
2. A container database is restarted for maintenance. The root opens without error,…
3. A vendor must add two columns to a shared table and make the change reach every …
4. A hosting provider must stop the administrators of a pluggable database from usi…
5. A software vendor hosts one product for many tenants inside a single container d…
6. A container database holds six pluggable databases, and only one of them has a n…
7. One data file has grown to several terabytes and its backup takes far longer tha…
8. The fast recovery area of a production database holds the recent backups and the…
9. A new database has to be configured so that the daily incremental backups finish…
10. A report fails with an error about a damaged block in one large table, and the r…
11. An operator deleted the rows of one table by mistake and committed the change te…
12. A DBA has to make the whole database able to be rewound to a point in the recent…
13. A single server will run one database, and the site wants the database, the list…
14. One pluggable database has to be moved from a container database at an earlier r…
15. A team wants to shorten the software installation on many hosts by unpacking the…
16. A site wants to distribute one prepared software directory to many hosts and pat…
17. A support case has to be opened for a failure that produced several kinds of fil…
18. Three applications share one database and the DBA needs to know which of them is…
19. An instance sometimes runs out of room in one memory pool while another pool is …
20. A DBA wants to compare the behavior of a database between two hours of last week…