A.Tables are scanned and index statistics recalculated when an instance is restarted.

B.Updating index statistics is an I/O expensive operation.

C.Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.

D.Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.

E.Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.

F.Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.

A.They are pushed from the master to the slave.

B.They contain events that describe database changes on the master.

C.They contain events that describe all queries run on the master.

D.They contain events that describe only administrative commands run on the master.

E.They are pulled from the master to the slave.

A.It encrypts any connecting slaves connection thread.

B.It requires a keyring plugin.

C.It can be set at run time.

D.It can be activated per session.

E.When enabled it encrypts existing binary logs.

A.It supports only non-blob datatypes.

B.It enforces encryption from disk to memory and over network transmission.

C.It decrypts data for use in memory.

D.It does not support the transportable tablespaces feature.

E.It supports all indexes transparently.

A.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

B.It is not necessary because innodb_data_home_dir is already defined.

C.It defines all innodb tablespace options relative to a starting parent directory.

D.It allows scanning of other locations to discover more innodb tablespaces.

E.It adds more temporary workspace in addition to the innodb_tmpdir location.