MySQL 8.0 Database Administrator: 1Z0-908

Examine these entries from the general query log:

All UPDATE statements reference existing rows.

Which describes the outcome of the sequence of statements?

A. Connection 24 experiences a lock wait timeout.

B. Connection 25 experiences a lock wait timeout.

C. A deadlock occurs immediately.

D. All statements execute without error.

E. A deadlock occurs after innodb_lock_wait_timeout seconds.

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Which two statements are true? (Choose two.)

A. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.

B. Executing ALTER TABLE transactions will enable you to free up disk space.

C. Truncating the sales and leads table will free up disk space.

D. Truncating the transactions table will free up the most disk space.

E. The transactions table was created with innodb_file_per_table=OFF.

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

A. It supports only non-blob datatypes.

B. It does not support the transportable tablespaces feature.

C. It supports all indexes transparently.

D. It decrypts data for use in memory.

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