試験内容は定期的に見直されるため、古い教材では安心できません。GoShikenのOracle MySQL 8.0 Database Administrator練習問題は2026年の出題範囲に沿って更新されており、1z1-908の最新の出題傾向を押さえた内容です。ご購入後365日間は無料で最新版をご利用いただけます。

Oracle 1z1-908 試験概要:

Oracle 1z1-908 試験シラバストピック:

1z1-908試験に関するQ&Aまとめ

Oracle MySQL 8.0 Database Administrator 認定 1z1-908 試験問題：

問題 #1

Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

A. The relay logs from the master should be used to replace the corrupted relay logs.
B. The slave relay logs should be deleted; then execute START SLAVE;
C. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
D. The slave needs to be restored from backup.

問題 #2

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

A. on master: --replicate-ignore-db=example
B. on slave: --binlog-ignore-db=example
C. on master: --binlog-ignore-db=example
D. on slave: --replicate-wild-ignore=example.%
E. on slave: --replicate-ignore-db=example

問題 #3

Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

A. Each slave thread is responsible for updating a specific database.
B. Setting transaction_allow_batching to on will improve data consistency.
C. Increasing slave_parallel_workers will improve high availability.
D. Setting slave_preserve_commit_order to on will improve data consistency.
E. Cross-database constraints can cause database inconsistency.
F. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

問題 #4

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

A. min_examined_row_limit=5000
B. log_throttle_queries_not_using_indexes=5
C. long_query_time=5
min_examined_row_limit=5000
D. long_query_time=5
log_throttle_queries_not_using_indexes=5
E. log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000
F. long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000
G. long_query_time=5

問題 #5

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A. replication
B. audit of all queries
C. point-in-time recovery
D. logging the duration and locks for all queries
E. recording the order in which queries are issued

解説：