A.Hot

B.Binary

C.Logical

D.Incremental

A.It caches index blocks for MyISAM tables only.

B.It caches index blocks for all storage engine tables.

C.It is a global buffer.

D.It is set on a per-connection basis.

E.It caches index blocks for InnoDB tables only.

A.It is a shared-nothing architecture.

B.It relies on the shared disk architecture being visible to both servers.

C.It implements High Availability by using the NET Connector's load balancing capabilities.

D.It is provided by means of IP-level disk replication.

A.The validate_passwordplug-in has not been loaded.

B.The dictionary file is an insecure location.

C.The name of the dictionary file is too obvious.

D.The dictionary file word list is too short.

E.validate_password_policycannot be set without restarting the MySQL instance.

F.validate_password_dictionary_filecannot be set without restarting the MySQL instance.

A.The event with event_id = 8945is a child of the event with event_id=8944.

B.The query read data from the data file rather than directly from the buffer pool.

C.The query did not find its table in the table definition cache.

D.The time the query took is the sum of all timer_waitvalues.