多項選擇題

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'

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

Which two capabilities are granted with the SUPER privilege?（）

你可能感興趣的試題

A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?（）