1z0-883
单选题The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’; When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@
题目
The password is eight characters long, but needs to exceed validate_password_length to be valid
All of the MEDIUM password policy requirements have not been honored
The password matches a substring Hover as a dictionary word
The password does not match the validate_passoword_number_count requirement
There is no dictionary file defined, so password validation cannot work as expected
相似问题和答案
第1题：
The validate_password plugin is loaded and displays the following settings in global variables: Mysql＞ SHOW VARIABLES LIKE ‘validate_password%’;When attempting to set your password, you get the following error: Mysql＞ SET PASSWORD = PASSWORD (‘Hoverl@%’);ERROR 1819 (HY000): Your password does not satisfy the current policy requirements What is the cause of the error?（）
A.The password is eight characters long, but needs to exceed validate_password_length to be valid
B.All of the MEDIUM password policy requirements have not been honored
C.The password matches a substring Hover as a dictionary word
D.The password does not match the validate_passoword_number_count requirement
E.There is no dictionary file defined, so password validation cannot work as expected
第2题：
A.
B.
C.
D.
第3题：
Consider the MySQL Enterprise Audit plugin.On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error.In the audit log file, you notice the final entry:…What action should you take to fix the error and allow the service to start?（）
A.Re-install the audit plugin
B.Execute the command FLUSH LOGS
C.Execute the command SET GLOBAL audit_log_fiush= ON
D.Move or rename the existing audit.log file
第4题：
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: /＞ mysqld – install Mysql56 – defaults – file = C :/my –opts.cnf What is the expected outcome?（）
- A、Mysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration file
- B、An error message is issued because – install is not a valid option for mysqld
- C、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnf
- D、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
正确答案:A
第5题：
As a candidate for CCNA examination， when you are familiar with the basic commands， if you input thecommand "enable secret level 5 password" in the global mode ， what does it indicate？（）
- A、Set the enable secret command to privilege level 5
- B、The enable secret password is hashed using MD5
- C、The enable secret password is for accessing exec privilege level 5
- D、The enable secret password is hashed using SHA
- E、The enable secret password is encrypted using Cisco proprietary level 5 encryption
正确答案:C
第6题：
You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）
A.Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file
B.An error message is issued because – install is not a valid option for mysqld
C.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf
D.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
第7题：
You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 You erroneously deleted the password file while the database was running. You re-create the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4 However， when you try to connect as the SYS user， you receive the following error： ORA-01031： insufficient privileges What should you do to resolve this error？（）
- A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
- B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
- C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
- D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.
正确答案:D
第8题：
You have forgotten the root user account password. You decide to reset the password and execute the following:Shell＞ /etc/init.d/mysql stopShell＞ /etc/init.d/mysql start – skip-grant tablesWhich additional argument makes this operation safer?（）
A.–skip-networking, to prohibit access from remote locations
B.–reset-grant-tables, to start the server with only the mysql database accessible
C.–read-only,to set all data to read-only except for super users
D.–old-passwords, to start Mysql to use the old password format while running without the grant tables
第9题：
An administrator notices that every time a particular server is restarted it requires a password in order for the server to begin the start up process. Which of the following is the reason this is happening？（）
- A、The server needs to have the password service verified and reconfigured.
- B、The server administrator has set a password policy in Group Policy.
- C、The server has the BIOS setting configured incorrectly.
- D、The server is set with a boot password before accessing the OS
正确答案:D
第10题：
You are attempting to secure a MySQL server by using SSL encryption. On starting MySQL, you get this error: 130123 10:38:02 [ERROR] mysqld: unknown option '—ssl' What is the cause of the error?（）
- A、The — ssl level was not specified
- B、The server was not started with the – enable–ssl-plugin option
- C、— ssl is not a valid server option
- D、The mysqld binary was not compiled with SSL support
- E、The server's SSL certificate was invalid
正确答案:C