Free Access Oracle.1Z1-888.v2022-07-14.q104 Practice Test (Page 17)

Question 76

The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.
Which three statements will succeed when executed by [email protected]? (Choose three.)

A.GRANT SELECT ON audit.* TO [email protected];

B.GRANT SELECT ON world.* TO [email protected];

C.GRANT SELECT ON world.* TO [email protected];

D.GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

E.CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

F.GRANT DELETE ON world.* TO [email protected];

G.GRANT INSERT ON audit.* TO [email protected];

Question 77

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

A.They will have their passwords updated on start-up to sha256_password format.

B.They are not affected by this configuration change.

C.They all connect via the secure sha256_password algorithm without any configuration change.

D.They will have to change their password the next time they login to the server.

Question 78

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a
.mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)

A.It provides means to help avoid accidentally exposing the MySQL login details.

B.A .mylogin.cnf file can store at most one login path.

C.It is an alternative to storing the MySQL login details in a my.cnf file.

D.A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

E.It provides a FIPS-compliant keyring for storing MySQL login details.

F.mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.