A.The lock is at the metadata object level.

B.The lock is an intentional lock.

C.The lock is at the table object level.

D.The lock is a shared lock.

E.The lock is a row-level lock.

F.The lock is an exclusive lock.

A.Mark can grant the r_read@localhost role to another user.

B.Mark can grant the privileges assigned to the r_read@localhost role to another user.

C.Mark can revoke the r_read@localhost role from another role.

D.Mark must connect from localhost to activate the r_read@localhost role.

E.ADMIN OPTION allows Mark to drop the role.

F.ADMIN OPTION causes the role to be activated by default.

A.InnoDB

B.MEMORY

C.NDB

D.MyISAM

E.ARCHIVE

A.It monitors and schedules the rotation/deletion of the binary logs.

B.It reads the relay log and executes the events contained in them.

C.It connects to the master and asks it to send updates recorded in its binary logs.

D.It acquires a lock on the binary log for reading each event to be sent to the slave.

A.MySQL server was not started due to a problem while executing process 2732.

B.systemdattempted to start mysqld, found another systemd mysqldprocess running, and shut it down.

C.systemd found the mysqldservice disabled and failed to start it.

D.systemdwaited for 30 seconds before timing out and start up failed.

E.MySQL server continued to start up even though another process existed.