A.Temporary tables are created in tmpdir only after they reach tmp_tabie_size.

B.Temporary tables are created in tmpdir only if configured to use MyISAM.

C.Temporary tables will use the InnoDB temporary tablespace located in datadir.

D.Only internal temporary tables from the optimizer will be created in tmpdir.

E.Temporary tables will use the InnoDB temporary tablespace located in /tmp.

A.Use system tools to lock each instance to its own CPU.

B.Run mysqld with --datadir defined for each instance.

C.Use systemd with different settings for each instance.

D.Start mysqld or mysqld_safe using different option files for each instance.

E.Run MySQL Server docker containers.

F.Use resource groups to lock different instances on separate CPUs.

A.Set validate-user-plugins=caching_sha2_password in the configuration file.

B.Add default_authentication_plugin=mysql_native_password in the configuration file.

C.Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

D.Add default_authentication_plugin=sha256_password in the configuration file.

A.any user created without a password

B.any user set as DEFINER for stored programs

C.any new ROLE accounts

D.any user created with a username, but missing the host name

E.any internal system accounts

A.Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

B.Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

C.Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

D.Logical upgrades are much faster because they do not require restarting the mysqld process.

E.Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

F.Physical upgrades are much faster because they do not require restarting the mysqld process.