单选题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 validB All of the MEDIUM password policy requirements have not been honoredC The password matches a substring Hover as a dictionary wordD The password does not match the validate_passoword_number_count requirementE There is no dictionary file defined, so password validation cannot work as expected
单选题
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
参考解析
解析：
暂无解析
相关考题：
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 pluginB.Execute the command FLUSH LOGSC.Execute the command SET GLOBAL audit_log_fiush= OND.Move or rename the existing audit.log file
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 locationsB.–reset-grant-tables, to start the server with only the mysql database accessibleC.–read-only,to set all data to read-only except for super usersD.–old-passwords, to start Mysql to use the old password format while running without the grant tables
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 validB.All of the MEDIUM password policy requirements have not been honoredC.The password matches a substring Hover as a dictionary wordD.The password does not match the validate_passoword_number_count requirementE.There is no dictionary file defined, so password validation cannot work as expected
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 fileB.An error message is issued because – install is not a valid option for mysqldC.A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnfD.Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file
After attempting to telnet into a router, you are denied and you receive the error message "password required, but none set." What configuration changes will allow telnet access into this router?() A.B.C.D.
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.
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 5B、The enable secret password is hashed using MD5C、The enable secret password is for accessing exec privilege level 5D、The enable secret password is hashed using SHAE、The enable secret password is encrypted using Cisco proprietary level 5 encryption
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
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 fileB、An error message is issued because – install is not a valid option for mysqldC、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfD、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
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 specifiedB、The server was not started with the – enable–ssl-plugin optionC、— ssl is not a valid server optionD、The mysqld binary was not compiled with SSL supportE、The server's SSL certificate was invalid
You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）A、The RPM installation script sets a default password of password for new installationsB、The local root user must log in with a blank password initially: mysql –u root –pC、New security measures mean that the mysql_secure_installation script must be run first on all new installationsD、The mysql_install_bd post-installation script used – random-password
You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A、–skip-networking, to prohibit access from remote locationsB、–reset-grant-tables, to start the server with only the mysql database accessibleC、–read-only,to set all data to read-only except for super usersD、–old-passwords, to start Mysql to use the old password format while running without the grant tables
You have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）A、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.B、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.C、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file isD、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.
You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）A、 executing the SET PASSWORD command and then the SAVE_CONFIG commandB、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC、 executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command
修改MySQL用户root的密码的指令是（）。A、mysqladmin -u root password testB、mysql -u root password testC、mysql -u root -p testD、mysql -u root -password test
Your portable computer is in sleep mode. When you resume work on the portable computer， you are not prompted for a password. You need to ensure that you are prompted for a password each time the portable computer recovers from sleep mode. What should you do？（）A、Configure the computer to hibernate when not in use.B、In the current power plan settings， configure the computer to require a password when recovering from sleep mode.C、Configure the computer to use the High Performance power plan.D、Configure the screen saver settings to require a password on resumption of work.
单选题You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）AThe RPM installation script sets a default password of password for new installationsBThe local root user must log in with a blank password initially: mysql –u root –pCNew security measures mean that the mysql_secure_installation script must be run first on all new installationsDThe mysql_install_bd post-installation script used – random-password
单选题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A–skip-networking, to prohibit access from remote locationsB–reset-grant-tables, to start the server with only the mysql database accessibleC–read-only,to set all data to read-only except for super usersD–old-passwords, to start Mysql to use the old password format while running without the grant tables
单选题You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）A–skip-networking, to prohibit access from remote locationsB–reset-grant-tables, to start the server with only the mysql database accessibleC–read-only,to set all data to read-only except for super usersD–old-passwords, to start Mysql to use the old password format while running without the grant tables
单选题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？（）AThe server needs to have the password service verified and reconfigured.BThe server administrator has set a password policy in Group Policy.CThe server has the BIOS setting configured incorrectly.DThe server is set with a boot password before accessing the OS
单选题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?（）AMysql is installed as the Windows service name Mysql56, and uses c: /my-opts.cnf as the configuration fileBAn error message is issued because – install is not a valid option for mysqldCA running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: /my-opts.cnfDMysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: /my-opts.cnf configuration file
单选题You have created a password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3 Which of the following is true about this password file？（）A If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.B If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.C If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file isD If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.
单选题You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）A executing the SET PASSWORD command and then the SAVE_CONFIG commandB executing the CHANGE_PASSWORD command and then the SAVE_CONFIG commandC executing the CHANGE_PASSWORD command and then the SET PASSWORD commandD executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command
单选题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 pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file
单选题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.
单选题Your portable computer is in sleep mode. When you resume work on the portable computer， you are not prompted for a password. You need to ensure that you are prompted for a password each time the portable computer recovers from sleep mode. What should you do？（）AConfigure the computer to hibernate when not in use.BIn the current power plan settings， configure the computer to require a password when recovering from sleep mode.CConfigure the computer to use the High Performance power plan.DConfigure the screen saver settings to require a password on resumption of work.
单选题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?（）AThe — ssl level was not specifiedBThe server was not started with the – enable–ssl-plugin optionC— ssl is not a valid server optionDThe mysqld binary was not compiled with SSL supportEThe server's SSL certificate was invalid