A.if there are any indexes that may be used to solve this query

B.whether there are any indexes on the tables that you are querying

C.if it is possible for you to include any indexes in your query

D.whether there are any indexes in your query

A.ALTER USER 'root'@'localhost' ACCOUNT LOCK;

B.ALTER USER ''@'localhost' PASSWORD = 'secret_password';

C.ALTER USER bob PASSWORD = 'secret_password';

D.DROP USER ''@'localhost';

E.REVOKE ALL PRIVILEGES FROM ''@'localhost';

F.ALTER USER bob@'%' IDENTIFIED BY 'secret_password';

A.max_connections requires the GLOBALscope.

B.Its current user does not have the SUPERprivilege.

C.max_connections is not a dynamic variable. You need to change the config file and restart the database.

D.Users can control only the max_user_connectionsvariable.

A.Use the command: SHOW TABLE STATUS

B.Query the performance_schema.objects_summary_global_by_type table

C.Query the INFORMATION_SCHEMA.PARTITIONS table

D.Use the command: SHOW CREATE TABLE

E.Query the INFORMATION_SCHEMA.TABLES table for the partition_count

A.The engine type is not appropriate to the application use.

B.The User field is too long for most names.

C.Date should be a TIMESTAMP field for better performance.

D.No indexes are defined.

E.Using default values for DATETIME causes table scans.