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

B.whether you are using any indexes in your query

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

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

A.It is amount of buffers available during a transaction.

B.It caches only the indexes for InnoDB tables.

C.It caches data and indexes for InnoDB tables.

D.It holds changes made during a transaction before they are written to the log.

E.It is a pool of memory for SQL query sort operations from within the InnoDB engine.

A.Increase the value of the innodb_lock_wait_timeoutoption.

B.Set the value of innodb_adaptive_hash_indexto zero.

C.Change the table to use HASH indexes instead of BTREE indexes.

D.Deactivate the query cache.

E.Increase the value of the innodb_read_io_threadsoption.

F.Increase the size of the InnoDB buffer pool.

A.All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

B.It results in a syntax error because you cannot specify more than one partition in the same statement.

C.All data in p1 and p3 partitions is removed and the table definition is changed.

D.Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

A.Logical backups are always larger than physical backups.

B.Logical backups are human-readable whereas physical backups are not.

C.Physical backups are usually slower than text backups.

D.Physical backups can be used to recover from data corruption.

E.Physical backups are usually faster than text backups.