A.information_schema

B.world

C.employee

D.sys

E.mysql

A.named pipes

B.shared memory

C.SOCKET

D.X Protocol

E.UDP

F.TCP/IP

A.user_variables_by_thread

B.global_variables

C.variables_by_thread

D.session_variables

A.mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

B.mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

C.mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql

D.mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

A.ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

B.ALTER TABLE employees -
ADD INDEX (birth_date DESC);

C.ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

D.ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

E.ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

F.ALTER TABLE employees -
ADD INDEX (birth_date);