MySQL 8.0 Database Administrator 試験対策問題集

模擬試験モードの設定

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

出題分野

• Architecture（アーキテクチャと格納の仕組み）（出題比率 11%）
• Server Installation and Configuration（導入と設定）（出題比率 15%）
• Security（利用者・権限・暗号化）（出題比率 22%）
• Monitoring and Maintenance（監視と保守）（出題比率 13%）
• Query Optimization（問い合わせの最適化）（出題比率 8%）
• Backups and Recovery（バックアップと復旧）（出題比率 12%）
• High Availability Techniques（複製とクラスタ）（出題比率 19%）

フリー問題

1. A client program runs on the same Unix host as the server and is started with th…
2. An administrator lists the data directory of a running server and finds one subd…
3. A team replaces the binaries of a running installation with a newer release of t…
4. A shutdown is requested while one session still has an open transaction that has…
5. A freshly unpacked release must be prepared so that the data directory ends up h…
6. A review flags the ability of clients to read files from their own machine into …
7. A policy says that a new account must change its password at the first login bef…
8. A hardening review asks which directory the operating system account that runs t…
9. A policy has to reject passwords that appear in a list of common words even when…
10. An operator renames the slow query log file from outside the server and nothing …
11. An administrator wants a record of every statement that a client sends, includin…
12. The slow query log is full of statements that finish in a fraction of a millisec…
13. A team wants to see how many rows each step of a finished statement really produ…
14. A team has to pick which statements to tune first from a list that shows both th…
15. A backup has to be taken every night from a production server that must not be s…
16. A raw copy of the data directory is taken with an ordinary file copy program and…
17. A replication topology has to allow an automatic change of the source when the c…
18. A replica falls further and further behind although its host has spare processor…
19. A replica has to survive a sudden power loss without ever applying the same tran…
20. An application must not have to know which member of a cluster is currently the …