MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ21Ìâ21¡¢Choose two.There are five MySQL instances configured with a working group replication.Examine the output of the group members:mysql> SELECT MEMBER_ID, MEMBER_STATE FROM performance_schema.replication_group_members;Wh...[Ïêϸ]

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ20Ìâ20¡¢Choose two.You plan to install MySQL Server by using the RPM download.Which two statements are true?A) You must manually initialize the data directory.B) You can provide the root password interactively.C) The MySQL RPM pa...[Ïêϸ]

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ19Ìâ19¡¢Choose two.User account baduser@hostname on your MySQL instance has been compromised.Which two commands stop any new connections using the compromised account?A) ALTER USER baduser@hostname PASSWORD DISABLED;B) ALTER US...[Ïêϸ]

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ18ÌâChoose two.You are using mysqlcheck for server maintenance.Which two statements are true?A) The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.B) The mysqlcheck --repai...[Ïêϸ]

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ17ÌâChoose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?A) /usrB) /usr/mysqlC) /etc/my.cnfD) /var/1ib/mysqlE) /usr/bin[Ïêϸ]

MySQL 8.0 OCPÈÏÖ¤¿¼ÊÔÔ­ÌâÌâ¿âÕûÀí(CUUGÄÚ²¿×ÊÁÏ)-µÚ16ÌâChoose two.Which two authentication plugins require the plaintext client plugin for authentication to work?A) LDAP authenticationB) SHA256 authenticationC) Windows Native authenticationD) PAM authenticationE) MySQL Native Pa...[Ïêϸ]