A.Convert the column to TEXT and add a fulltext index to the table
B.Create multiple prefix indexes of differing lengths
C.Convert their column to BINARY
D.Redesign the table so that the most commonly searched for string patterns are in their own columns

A.Transaction support
B.FULLTEXT indexing for text matching
C.Table and page level locking support
D.Foreign key support
E.Geospatial indexing
F.HASH index support
G.Table level locking only

A.Each extra column in the copy with more columns must not have a default value
B.Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C.The slave database cannot have more columns than the master. Only the master database can have more columns
D.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

A.The — ssl level was not specified
B.The server was not started with the – enable–ssl-plugin option
C.— ssl is not a valid server option
D.The mysqld binary was not compiled with SSL support
E.The server's SSL certificate was invalid

A.Table_open_cache
B.Table_open_cache_instancs
C.Table_definition_cache
D.Tmp_table_size
E.Max_heap_table_size
F.Max_tmp_tables

A.A
B.B
C.C
D.D
E.E

A.FORCE_PLUS_PERMANENT is not valid for the audit-log option
B.The audit_log.so library does not exist
C.The audit_log.so library is in a location that is different from that defined by the plugin_dir option
D.The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command
E.The audit log file does not exist in which to write audit events
F.The audit_log.so library is not an executable file

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

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

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.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'