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

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

C.It caches only the indexes for InnoDB tables.

D.It caches data and indexes for InnoDB tables.

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

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

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

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

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

A.query cache

B.thread cache

C.read buffer

D.internal temporary table

E.sort buffer

F.InnoDB buffer pool instance

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

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

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

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

A.Thread memory is pre-allocated up to thread_cache_size for performance.

B.Each thread allocates memory from a global pool.

C.Global memory resources are allocated at server startup.

D.Each connection may have its own per-thread memory allocations.