live chatMcAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Pass4Test 10%OFF Discount Code

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?
Correct Answer: B
QUESTION NO: 2
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.)
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?
Correct Answer: C
QUESTION NO: 5
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.)
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.)
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?
Correct Answer: A
QUESTION NO: 9
Examine this statement and output:

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