1Z0-908.pdf
Q: 1
Which two commands will display indexes on the parts table in the manufacturing schema? (Choose
two.)
Options
Q: 2
Examine this query:
What information does this query provide?
What information does this query provide?Options
Q: 3
Which statement is true about cold backups?
Options
Q: 4
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:
Which statement is true?
Which statement is true?Options
Q: 5
Which two are true about differences between logical and physical upgrades of MySQL databases?
(Choose two.)
Options
Q: 6
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data
directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
Options
Q: 7
Which two are use cases of MySQL asynchronous replication? (Choose two.)
Options
Q: 8
Which two statements are true about the binary log encryption feature? (Choose two.)
Options
Q: 9
Which three sets of item information are visible in the mysql system database? (Choose three.)
Options
Q: 10
How can mysql_multi be configured to allow MySQL instances to use the same port number?
Options
Question 1 of 10
