1Z1-888 無料問題集「Oracle MySQL 5.7 Database Administrator」

（A）enables automatic resync of databases when discrepancies are detected

（B）supports native automatic failover

（C）synchronously guarantees identical slave copy

（D）can easily add slaves for read scaling

（E）provides arbitrary geographic redundancy with minimal overhead to master

（F）is easy to configure and has low performance overhead

（A）Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

（B）Ensure that none of the attached slaves are using any of the binary logs you want to delete.

（C）Execute the PURGE BINARY LOGS NOT USED command.

（D）Edit the .index file to remove the files you want to delete.

（E）Remove all of the binary log files that have a modification date earlier than today.

（A）It is possible to restore the data in parallel.

（B）It can be piped directly into a running server.

（C）It can be used together with --all-databases.

（D）The schema and data are automatically dumped to separate files.

（A）The master has performed a large transaction, which will take 360 seconds to complete on the slave.

（B）The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

（C）The slave was configured for delayed replication with a delay of six minutes.

（D）The network latency between the master and the slave is 360 milliseconds.

（A）They will have to change their password the next time they login to the server.

（B）They are not affected by this configuration change.

（C）They all connect via the secure sha256_password algorithm without any configuration change.

（D）They will have their passwords updated on start-up to sha256_password format.

（A）The validate_password plug-in has not been loaded.

（B）validate_password_policy cannot be set without restarting the MySQL instance.

（C）validate_password_dictionary_file cannot be set without restarting the MySQL instance.

（D）The dictionary file word list is too short.

（E）The name of the dictionary file is too obvious.

（F）The dictionary file is an insecure location.

（A）The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

（B）The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

（C）The transaction isolation level determines which transaction is rolled back.

（D）Both the affected transactions will be rolled back.

（E）One of the affected transactions will be rolled back, the other is allowed to proceed.

（A）monitoring the information_schemA.TABLES table

（B）monitoring cumulative Innodb_page_size increase

（C）monitoring the Innodb_rows_inserted status variable

（D）monitoring the performance_schema_hosts_size variable

（E）monitoring the innodb_redo_log_size variable

（F）monitoring datadir size in the operating system