Free Access Oracle.1Z0-888.v2022-11-15.q104 Practice Test (Page 11)

Question 46

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

A.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@'';

B.mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';

C.mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';

D.mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

Question 47

Why should you be selective when granting the PROCESSprivilege to an account?

A.It allows a client to process scripts.

B.It allows the use of stored routines.

C.It allows a client to see another user's queries with the SHOW PROCESSLISTcommand.

D.It allows a client to control running processes on a server.

Question 48

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysqlsystem database are missing. Which step do you perform to create the contents of the data directory?

A.Run the create_system_tables.sqlfile

B.Run the mysql_unpack.sqlfile

C.Invoke mysqldwith the --initializeoption.

D.Invoke mysqlwith the --initializeoption.

Question 49

Consider these global status variables:

Which two conclusions can be made from the output? (Choose two.)

A.All max_connectionswere in use at 2018-03-22 14:54:06

B.There are 140 Performance Schema threads at the time of the output.

C.The thread cache has been configured with thread_cache_sizeset to at least 6.

D.There are more connections being idle than executing queries.

E.There are 510 connections to MySQL at the time of the output.

Question 50