mysql8.0英文OCP考试第101-110题

Q101.Examine this command and output:

mysql> SELECT . FROM data_ locks LIMIT 1\G

******************************************************************

ENGINE: INNODB

ENGINE LOCK ID: 1200: 14 6

ENGINE T RANSACTION ID: 1200

THREAD ID: 45

EVENT ID:11

OBJECT SCHEMA: mydb

OBJECT NAME: mytable1

PARTITION NAME: NULL

SUBPARTITION NAME: NULL

INDEX NANE: NULL

OBJECT INSTANCE BEGIN: 118793337250203

LOCK TYPE: RECORD

LOCK,MODE:X

LOCK_ STATUS : GRINTED

LOCK_ DATA: 1922, 1922

Which two statements are true?

A)The lock is a row-level lock.

B)The lock is at the table object level.

C)The lock is at the metadata object level.

D)The lock is an intentional lock.

E)The lock is a shared lock.

F)The lock is an exclusive lock.

Answer:AF

Q102.You must run multiple instances of MySQL Server on a single host.Which three methods are supported?

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

B)Run MySQL Server docker containers.

C)Use systemd with different settings for each instance.

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

E)