1Z0-920 Online Practice Questions and Answers

Which statement would you use to remove the population column from the city table?

A. ALTER TABLE city DROP population;

B. DELETE population FROM city;

C. ALTER TABLE city DELETE population;

D. ALTER TABLE city LESS population;

E. DROP population FROM city;

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

A. You forgot to enable port 3306.

B. The opc user can be used to access MySQL only with the created SSH-Key.

C. Only root is allowed to access from non-localhost.

D. You forgot to create the correct SSL/TLC certificate during the setup process.

E. The OCI instance is still in the "creation" process.

You need to change the password level for a test system. Which two allow to change this level before you create new test user/passwords?

A. Add validate_password='new level' in the [security] section of the MySQL configuration file.

B. SET GLOBAL validate_password_policy='new level';

C. SET GLOBAL force_password_complex_policy=0;

D. Add validate_password_policy='new level' in the [mysqld] section of the MySQL configuration file.

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug- in

from being removed at run time.

Which two options should you include in the MySQL configuration file?

A. audit_log_permanent=ON

B. audit-log=FORCE_PLUS_PERMANENT

C. plugin-load=audit_log.so

D. plugin-audit=ON, ALWAYS

E. LOAD PLUGIN=AUDIT_LOG

The MySQL Replication Environment (Master and Slave) is prepared. What two are options for connecting a Java application to the MySQL Master and Slave?

A. Option A

B. Option B

C. Option C

D. Option D

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. REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'joe'@'%';

C. UPDATE mysql.user SET Password=PASSWORD('Invalid') WHERE User='joe';

D. Insert Joe's name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

E. CREATE USER ' joe'@1' %' DENY ALL PRIVILEGES

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 SHA256 hashing for user account passwords?

A. Create user by using CREATE USER `newuser' @'localhost' SET PASSWORD AS `Sh@256Pa33';

B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

D. Create user by using CREATE USER `newuser'@'localhost' IDENTIFIED WITH `Sh@256Pa33';

By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.

B. MySQL Enterprise Backup will back up from Slave automatically.

C. It provides multi-master access where the application can write and read data across the database servers.

D. It allows backup to be done on the slave without impacting the master.

E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

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 password inserted in the error log set by the --log-error=[file_name] variable

C. The root password displayed on the screen via a [warning] message.

D. The root_pw variable stored in the mysq1.install table.

E. As root, execute the show password command by using the SHA-256 password encryption plug-in.

Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

B. MySQL Enterprise Authentication determines what operation the user can perform.

C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

D. MySQL Enterprise Authentication supports Windows Active Directory.

E. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..