1Z0-920 무료 덤프문제 온라인 액세스

How would you restrict a user Joe from accessing all MySQL database objects?

• A.CREATE USER 'joe'@'0.0.0.0' SET Password=PASSWORD('% ! %')
• B.CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES
• C.REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';
• D.Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
• E.UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

• A.The root password is not given and is blank. You must manually set the root password.
• B.The root_pw variable stored in the mysq1.install table.
• C.The root password inserted in the error log set by the --log-error=[file_name] variable
• D.The root password displayed on the screen via a [warning] message.
• E.As root, execute the show password command by using the SHA-256 password encryption plug-in.

MySQL is installed on a Linux server with the configuration:

Which two methods can change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

• A.Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• B.Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';
• C.Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• D.Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?

• A.strict or relaxed masking
• B.dictionary substitution
• C.whitelisting and substitution
• D.misspelling
• E.random data substitution

What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

• A.SMS-notification tab on the dashboard
• B.Application-to-application messaging
• C.Direct support call from an Oracle representative
• D.Browser pop-ups
• E.Email