多选题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 stopEShell＞ service mysql safe_exitFShell＞ pkill –u mysql mysqld

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

查看答案

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

查看答案

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

查看答案

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

查看答案

考题 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 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.AB.BC.CD.D

查看答案

考题 Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?() A.Mysql NDB ClusterB.Mysql ReplicationC.Distributed Replicated Block Device (DRBD) and MysqlD.Windows Cluster and MysqlE.Solaris Cluster and Mysql

查看答案

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

查看答案

考题 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.sqlC.Shell＞ mysql import –u root –p sakila sakila2013.sqlD.Shell＞ mysql –u root -p –e ‘use sakila; source sakila2013.sql‘E.Shell＞ mysql –u root –p –silent ＜ sakila2013.sql

查看答案

考题 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.sqlC、Shell＞ mysql import –u root –p sakila sakila2013.sqlD、Shell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'E、Shell＞ mysql –u root –p –silent ＜ sakila2013.sql

查看答案

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

查看答案

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

查看答案

考题 Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A、MySQL ReplicationB、Distributed Replication Block DeviceC、Windows Server Failover ClusteringD、MySQL Cluster

查看答案

考题 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 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 localB、login-path can be used only for MySQL servers running on a local machineC、login-path allows you to provide login credentials without passing clear text passwords on the command lineD、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

查看答案

考题 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 speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used

查看答案

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

查看答案

考题修改MySQL用户root的密码的指令是（）。A、mysqladmin -u root password testB、mysql -u root password testC、mysql -u root -p testD、mysql -u root -password test

查看答案

考题多选题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?（）ADisabling connections from named pipes or socket files (depending on the operating system of the server)BEnabling and using SSL for connections to the Mysql databaseCInstalling Mysql on the application server, and running the database and application on the same serverDStarting the server with – bind- address=0.0.0.0 specifiedERunning the server with – skip-networking specifiedFLimiting logins to originate from the application server or the server's subnet'

查看答案

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

查看答案

考题多选题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?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql

查看答案

考题多选题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.sqlBMysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'C$ mysql – u root – p – h localhost test ＜ /tmp/t1.sqlDMysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1E$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

查看答案

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

查看答案

考题多选题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?（）AMysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';BShell＞ mysql –u root –p sakila sakila2013.sqlCShell＞ mysql import –u root –p sakila sakila2013.sqlDShell＞ mysql –u root -p –e 'use sakila; source sakila2013.sql'EShell＞ mysql –u root –p –silent ＜ sakila2013.sql

查看答案

考题多选题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 stopEShell＞ service mysql safe_exitFShell＞ pkill –u mysql mysqld_safeGShell＞ net stop mysql

查看答案

考题单选题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 AB BC CD D

查看答案

考题单选题修改MySQL用户root的密码的指令是（）。A mysqladmin -u root password testB mysql -u root password testC mysql -u root -p testD mysql -u root -password test

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：