多项选择题
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 user executes the statement; PURGE BINARY LOGS TO mysql-bin.010; What is the result?()
单项选择题 You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()