Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

• A.PIPE
• B.SOCKET
• C.IPv4
• D.TCP
• E.FILE
• F.IPv6
• G.MEMORY
• H.DIRECT

Comment: *

Name: *

Email: *

Verification: *

You want to check the values of the sort_buffer_sizesession variables of all existing connections.
Which performance_schematable can you query?

• A.user_variables_by_thread
• B.global_variables
• C.variables_by_thread
• D.session_variables

Comment: *

Name: *

Email: *

Verification: *

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.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Use systemd with different settings for each instance.
• B.Start mysqld or mysqld_safe using different option files for each instance.
• C.Run mysqld with --datadir defined for each instance.
• D.Use system tools to lock each instance to its own CPU.
• E.Run MySQL Server docker containers.
• F.Use resource groups to lock different instances on separate CPUs.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which two statements are true? (Choose two.)

• A.The lock is at the table object level.
• B.The lock is an exclusive lock.
• C.The lock is a row-level lock.
• D.The lock is at the metadata object level.
• E.The lock is a shared lock.
• F.The lock is an intentional lock.

Comment: *

Name: *

Email: *

Verification: *