MySQL 8.0 Database Developer 試験対策問題集

模擬試験モードの設定

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

出題分野

• Connectors and APIs（コネクタと接続）（出題比率 16%）
• Data-driven Applications（データ駆動アプリケーション）（出題比率 20%）
• MySQL Schema Objects and Data（ビューとデータ型）（出題比率 16%）
• Transactions（トランザクションとロック）（出題比率 12%）
• Query Optimization（問い合わせの最適化）（出題比率 9%）
• MySQL Stored Programs（ストアドプログラム）（出題比率 12%）
• JSON and Document Store（JSONとドキュメントストア）（出題比率 15%）

フリー問題

1. A session issues SET NAMES 'utf8mb4' right after it opens, while the schema in u…
2. A remote server presents a valid certificate that a trusted authority signed, bu…
3. A developer starts a client on a Unix machine and passes --host=localhost togeth…
4. A report filters a field with the test phone = NULL, and some records in that fi…
5. A join must treat two absent readings as a pair so that missing data lines up on…
6. A grouped query also selects a field that is neither grouped nor wrapped in an a…
7. A summary must report how many lines a query brings out, even where a chosen col…
8. A CHAR(10) field receives a word of five letters. How does the server hold that …
9. A design wants an index over a field whose value the server works out on the fly…
10. Two fields hold the same short piece of prose that ends in blanks: one is declar…
11. Inside a transaction that has already taken its view of the data, a session issu…
12. Two sessions must both look at the same rows and be sure that nobody changes the…
13. A session runs several plain SELECT statements inside one transaction on InnoDB,…
14. A design tries to build the row identifier over the result of an expression, and…
15. A generated column carries an expression and has an index over it, and a query w…
16. A caller invokes a procedure that reports a tally through a parameter marked OUT…
17. Inside a trigger that fires for each row of an UPDATE, a body reads the qualifie…
18. A change must alter members that are already there and must not bring anything n…
19. A query reads one small member out of a large body of data held in a JSON column…
20. A path must find every member named b at any depth of the whole body of data. Wh…