Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-908 - MySQL 8.0 Database Administrator

Page: 5 / 5
Total 140 questions

Your MySQL server is running on the Microsoft Windows platform.

Which three local connection protocols are available to you? (Choose three.)

A.

named pipes

B.

shared memory

C.

SOCKET

D.

X Protocol

E.

UDP

F.

TCP/IP

User account baduser@hostname on your MySQL instance has been compromised.

Which two commands stop any new connections using the compromised account? (Choose two.)

A.

ALTER USER baduser@hostname PASSWORD DISABLED;

B.

ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;

C.

ALTER USER baduser@hostname ACCOUNT LOCK;

D.

ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;

E.

ALTER USER baduser@hostname DEFAULT ROLE NONE;