Online Access Free Oracle.1Z1-888.v2022-02-09.q146 Practice Test (Page 29)

1Z1-888 Exam Question 136

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

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

B.mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';

C.mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;

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

1Z1-888 Exam Question 137

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
(Choose two.)

A.mysql --protocol=PLAIN -uroot -p -h dbhost.example.com

B.INSTALL PLUGIN mysql_cleartext_password SONAME 'mysql_cleartext_password.so';

C.export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'

D.SET GLOBAL mysql_cleartext_passwords=1;

E.mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com

1Z1-888 Exam Question 138

Consider:

Which statement best describes the meaning of the values in the ref columns?

A.world.City.CountryCode is used as the primary key for the Country table.

B.No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

C.No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

D.world.City.CountryCode is used to sort the rows in the City table.

1Z1-888 Exam Question 139

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

A.binlog_format=STATEMENT

B.log-bin

C.apply-log

D.bonlog_format=ROW

E.gtid_enable

1Z1-888 Exam Question 140