网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 secure
B
MySQL needs to be run as the root user, but file cannot be owned by it
C
MySQL cannot be run as the root user
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
修改MySQL用户root的密码的指令是?()
A.mysqladmin-urootpasswordtestB.mysql-urootpasswordtestC.mysql-uroot-ptestD.mysql-uroot-passwordtest
考题
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）A.Activating the MySQL Enterprise thread pool pluginB.Relocating your data and log files to separate storage devicesC.Disconnecting idle localhost client sessionsD.Implementing storage engine data compression options
考题
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
考题
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 the query:Mysql＞ SET @run = 15;Mysql＞ EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformationWHERE run=@run AND objective=’7.1’GROUP BY objective,stageORDER BY stage;The iteminformation table has the following indexes;Mysql＞ SHOW INDEXES FROM iteminformation:This query is run several times in an application with different values in the WHERE clause in a growing data set.What is the primary improvement that can be made for this scenario?（）A.Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexesB.Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operationsC.Drop the run_2 index because it has caused a conflict in the choice of key for this queryD.Execute the run_2 index because it has caused a conflict in the choice of key for this queryE.Add a composite index on (run,objective,stage) to allow the query to fully utilize an index
考题
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
考题
You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）A、Mysqld uses internal configuration versioning and reverts to the previous configurationB、When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC、The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD、Mysqld prints to the error log about an unknown variable, and then exits
考题
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
考题
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）A、It deletes all binary log files, except 'mysql-in.010'B、It deletes all binary log files up to and including 'mysql-bin.010'C、It deletes all binary log files before 'mysql-bin.010'D、It deletes all binary log files after 'mysql-bin.010'
考题
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
考题
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）A、Activating the MySQL Enterprise thread pool pluginB、Relocating your data and log files to separate storage devicesC、Disconnecting idle localhost client sessionsD、Implementing storage engine data compression options
考题
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
考题
单选题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 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 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 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
考题
单选题A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）A
It deletes all binary log files, except 'mysql-in.010'B
It deletes all binary log files up to and including 'mysql-bin.010'C
It deletes all binary log files before 'mysql-bin.010'D
It deletes all binary log files after 'mysql-bin.010'
考题
单选题You adjust a default configuration to the following /etc/my.cnf on a Linux installation:[mysqld] Loq-bin Binrylog_format=ROW You do not notice the spelling error in binrylog_format and restart your production server. How does the MySQL server behave with incorrectly spelled options?（）A
Mysqld uses internal configuration versioning and reverts to the previous configurationB
When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakesC
The mysqld_safe script skips the unknown variable and starts using the remaining configuration changesD
Mysqld prints to the error log about an unknown variable, and then exits
考题
多选题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
考题
单选题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）A
Activating the MySQL Enterprise thread pool pluginB
Relocating your data and log files to separate storage devicesC
Disconnecting idle localhost client sessionsD
Implementing storage engine data compression options
考题
单选题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
热门标签
最新试卷
