1z0-888 V12.75.pdf
免费下载
Exam : 1z0-888
Title : MySQL 5.7 Database
Administrator
Vendor : Oracle
Version : V12.75
IT Certification Guaranteed, The Easy Way!
1
NO.1 To satisfy a security requirement, you have created or altered some user accounts to include
REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use
X509?
A. Install the X509 plug-in on the server.
B. Set the X509 option in the [client] section of the MySQL server's configuration file.
C. Restart the server with the --require-x509 option.
D. Distribute client digital certificates to the client computers being used to log in by the user
accounts.
E. Provide users access to the server's private key.
Answer: B
NO.2 A master-slave replication setup has the slave showing this error:
On the master server, the binary logs show:
What could explain this error? (Choose two.)
A. binlog_cache_size=1024 is too small and transactions are lost.
B. binlog_format=STATEMENT and a non-deterministic query was executed.
C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
D. The sync_relay_log=1000 setting on the slave is too small.
E. sync_binlog=0 and the master server crashed.
Answer: A,C
NO.3 You attempt to connect to a MySQL Server by using the mysql client program. However, you
receive this notice:
What would you run to fix the issue?
A. the mysql_upgrade script
B. the mysql client with the --ignore-password-hashing option
C. the mysql_secure_installation script to update server security settings
D. the mysql client with the --enable-cleartext-plugin option
E. the install plugin command for the mysql_cleartext_password plugin
Answer: C
Reference: http://planet.mysql.com/entry/?id=34077
IT Certification Guaranteed, The Easy Way!
2
of 33
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论