单项选择题
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
相关考题
-
多项选择题
Which two capabilities are granted with the SUPER privilege?（）
A.Allowing a client to kill other client connections
B.Allowing a client to shut down the server
C.Allowing change of the server runtime configuration
D.Allowing client accounts to take over the account of another user -
单项选择题
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 -
单项选择题
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'
