多选题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）AShell＞ mysqladmin –u root –p shutdownBShell＞ nmc mysql shutdownCMysql＞ STOP PROCESS mysqldDShell＞ /etc/init.d/mysql

题目
多选题
You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）
A

Shell＞ mysqladmin –u root –p shutdown

B

Shell＞ nmc mysql shutdown

C

Mysql＞ STOP PROCESS mysqld

D

Shell＞ /etc/init.d/mysql stop

E

Shell＞ service mysql safe_exit

F

Shell＞ pkill –u mysql mysqld_safe

G

Shell＞ net stop mysql

相似考题

1.修改MySQL用户root的密码的指令是?()A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest

2.MySQL is installed on a Linux server and has the following configuration:What is the purpose of changing ownership of datadir to the ‘mysql’ user?()A.MySQL requires correct file ownership while remaining secureB.MySQL needs to be run as the root user, but file cannot be owned by itC.MySQL cannot be run as the root user

3.In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）Mysql＞ SELECT * INTO OUTFILE ‘/tmp/t1.sql‘ from t1;mysql＞ TRUNCATE t1;A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sqlB.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlD.Mysql＞ LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

4.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 want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）AShell＞ mysqladmin –u root –p shutdownBShell＞ nmc mysql shutdownCMysql＞ STOP PROCESS mysqldDShell＞ /etc/init.d/mysql”相关问题

  • 第1题：

    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


    参考答案：A

  • 第2题：

    Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?()

    A.Mysql NDB Cluster

    B.Mysql Replication

    C.Distributed Replicated Block Device (DRBD) and Mysql

    D.Windows Cluster and Mysql

    E.Solaris Cluster and Mysql


    参考答案：A, B, C

  • 第3题：

    Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sqlWhich two commands will restore the sakila database without interfering with other running database?（）

    A.Mysql＞ USE sakila; LOAD DATA INFILE ‘sakila2013.sql‘;

    B.Shell＞ mysql –u root –p sakila sakila2013.sql

    C.Shell＞ mysql import –u root –p sakila sakila2013.sql

    D.Shell＞ mysql –u root -p –e ‘use sakila; source sakila2013.sql‘

    E.Shell＞ mysql –u root –p –silent ＜ sakila2013.sql


    参考答案：B, D

  • 第4题：

    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;

    • A、$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
    • B、Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
    • C、$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
    • D、Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
    • E、$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

    正确答案:D,E

  • 第5题：

    Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）

    • A、MySQL Replication
    • B、Distributed Replication Block Device
    • C、Windows Server Failover Clustering
    • D、MySQL Cluster

    正确答案:A

  • 第6题：

    You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

    • A、All system users have access to the MySQL server via—login path local
    • B、login-path can be used only for MySQL servers running on a local machine
    • C、login-path allows you to provide login credentials without passing clear text passwords on the command line
    • D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

    正确答案: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

    正确答案:D

  • 第8题：

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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
    A

    $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

    B

    Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'

    C

    $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

    D

    Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1

    E

    $ mysqlinport – u root – p – h localhost test /tmp/t1.sql


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

  • 第11题：

    多选题
    Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）
    A

    Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';

    B

    Shell＞ mysql –u root –p sakila sakila2013.sql

    C

    Shell＞ mysql import –u root –p sakila sakila2013.sql

    D

    Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'

    E

    Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql


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

  • 第12题：

    单选题
    The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第13题：

    The following commands are available in the Linux binary distributions of Mysql: Mysqld Mysqld_safe Mysql.server What is the correct description of each of these commands?()

    A.A

    B.B

    C.C

    D.D


    参考答案：A

  • 第14题：

    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

  • 第15题：

    Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）

    • A、Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';
    • B、Shell＞ mysql –u root –p sakila sakila2013.sql
    • C、Shell＞ mysql import –u root –p sakila sakila2013.sql
    • D、Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
    • E、Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql

    正确答案:B,D

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）

    • A、It exports tables with the most indexes first to assist with import speeds
    • B、It ensures that unique indexes have no conflicts when the data is dumped
    • C、It orders by primary key to assist in speeding up importing to InnoDB tables
    • D、It must be specified so index data is dumped correctly when  –on-create-info is used

    正确答案:C

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

    正确答案:A

  • 第20题：

    多选题
    A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
    A

    Disabling connections from named pipes or socket files (depending on the operating system of the server)

    B

    Enabling and using SSL for connections to the Mysql database

    C

    Installing Mysql on the application server, and running the database and application on the same server

    D

    Starting the server with – bind- address=0.0.0.0 specified

    E

    Running the server with – skip-networking specified

    F

    Limiting logins to originate from the application server or the server's subnet'


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

  • 第21题：

    多选题
    Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）
    A

    Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';

    B

    Shell＞ mysql –u root –p sakila sakila2013.sql

    C

    Shell＞ mysql import –u root –p sakila sakila2013.sql

    D

    Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'

    E

    Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）
    A

    Shell＞ mysqladmin –u root –p shutdown

    B

    Shell＞ nmc mysql shutdown

    C

    Mysql＞ STOP PROCESS mysqld

    D

    Shell＞ /etc/init.d/mysql stop

    E

    Shell＞ service mysql safe_exit

    F

    Shell＞ pkill –u mysql mysqld_safe

    G

    Shell＞ net stop mysql


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

  • 第24题：

    单选题
    修改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
    解析： 暂无解析

相关内容