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

单项选择题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'

单项选择题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?（）

A.The snapshot size will continue to grow as changes to the volume are made
B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data
C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup
D.The system keeps a copy of changes in memory and can cause an out of memory event

单项选择题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

多项选择题Which two options describe how MySQL Server allocates memory?（）

A.Thread memory is pre-allocated up to thread_cache_size for performance
B.Each connection may have its own per-thread memory allocations
C.Global memory resources are allocated at server startup
D.Each thread allocates memory from a global pool