单选题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 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

相似考题

1.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

2.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

3.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

4.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@”相关问题

  • 第1题：

    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.


    参考答案：C

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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 installations
    • B、The local root user must log in with a blank password initially: mysql –u root –p
    • C、New security measures mean that the mysql_secure_installation script must be run first on all new installations
    • D、The mysql_install_bd post-installation script used – random-password

    正确答案:D

  • 第5题：

    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 is
    • D、 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.

    正确答案:D

  • 第6题：

    修改MySQL用户root的密码的指令是（）。

    • A、mysqladmin -u root password test
    • B、mysql -u root password test
    • C、mysql -u root -p test
    • D、mysql -u root -password test

    正确答案:C

  • 第7题：

    单选题
    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 installations

    B

    The local root user must log in with a blank password initially: mysql –u root –p

    C

    New security measures mean that the mysql_secure_installation script must be run first on all new installations

    D

    The mysql_install_bd post-installation script used – random-password


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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 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


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    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 command

    B

     executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command

    C

     executing the CHANGE_PASSWORD command and then the SET PASSWORD command

    D

     executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the  SAVE_CONFIG command


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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 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

    正确答案:A

  • 第17题：

    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 command
    • B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
    • C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command
    • D、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the  SAVE_CONFIG command

    正确答案:D

  • 第18题：

    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.

    正确答案:B

  • 第19题：

    单选题
    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 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


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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 is

    D

     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.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

相关内容