
Oracle MySQL 8.0 Database Administrator - 1z1-908 Exam Questions
QUESTION NO: 1
Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?
Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?
Correct Answer: B
QUESTION NO: 2
Which step or set of steps can be used to rotate the error log?
Which step or set of steps can be used to rotate the error log?
Correct Answer: D
QUESTION NO: 3
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
Correct Answer: B,F
QUESTION NO: 4
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?
You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?
Correct Answer: C
QUESTION NO: 5
Which three sets of item information are visible in the mysql system database? (Choose three.)
Which three sets of item information are visible in the mysql system database? (Choose three.)
Correct Answer: C,E,F
QUESTION NO: 6
Which two statements are true about MySQL server multi-source replication? (Choose two.)
Which two statements are true about MySQL server multi-source replication? (Choose two.)
Correct Answer: D,F
QUESTION NO: 7
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
Correct Answer: A,B,D
QUESTION NO: 8
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?
Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'.
Which command will do this?
Correct Answer: A
QUESTION NO: 9
Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)
Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)
Correct Answer: B,C




