CMDEV认证培训包-3期（PX020） 习题2 PX 020 030202 166习题分析.docxVIP

第一题： A Mysql Server has been running an existing application successfully for six months.The f is adjusted to contain the following additional configuration:[mysqld]default-authentication-plugin=sha256_passwordThe Mysql Server is restarted without error.What effect will the new configuration have in existing accounts?A.They will have their passwords updated on start-up to sha256_password formatB.They will have to change their password the next time they login to the serverC.They are not affected by this configuration changeD.They all connect via the secure sha256_password algorithm without any configuration change.答案：C分析：default-authentication-plugin的作用是为了在create user时默认其所使用的密码加密格式。其和已经建立的用户所使用的密码格式无关，因此A,B错。在客户端工具进行连接时，服务端会在mysql.user表中进行匹配，以了解对应登陆用户所使用的密码格式，并以此授权方式进行登陆验证，因此D错。参考： /doc/refman/5.6/en/sha256-authentication-plugin.html 第二题： What are three actions performed by the mysql_secure_installation tool?A.It prompts you to set the root user account password.B.It checks whether file permissions are appropriate within datadir.C.It asks to remove the test database, which is generated at installation time.D.It can delete any anonymous accounts.E.It verifies that all users are configuration with the longer password hash.答案：ACD分析：mysql_secure_installation脚本工具仅可做以下四件事：1. 设置root用户密码2. 去除root用户的非本地访问账号3. 去除匿名用户账号4. 去除test数据库。参考： /doc/refman/5.6/en/mysql-secure-installation.html 第三题： Consider the query:?Mysql SET? @run?= 15;Mysql EXPLAIN SELECT objective, stage, COUNT(stage)FROM iteminformationWHERE run=@run AND objective=7.1GROUP BY objective,stageORDER BY stage;The iteminformation table has the following indexes;?Mysql SHOW INDEXES FROM iteminformation:?This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?A.Execute the run_2 index because it has caused a conflict in the choic