Free Oracle 1Z1-920 Exam Dumps Questions & Answers

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)

B)

C)

D)

• A.Option D
• B.Option B
• C.Option A
• D.Option C

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

• A.Simple Authentication and Security Layer
• B.Native Windows services
• C.authentication using SHA-256 password hashing
• D.SECURID authentication and authorization identity
• E.connections through the local host via the UNIX socket file
• F.authentication via Pluggable Authentication Modules (PAMs)

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

• A.monitoring the availability of the MySQL Instance
• B.deploying MySQL agent on supported target operating system
• C.starting and stopping the MySQL instance
• D.analyzing executed MySQL queries
• E.creating e-mail alerts and SNMP traps for MySQL warnings
• F.tracing import and export with mysqldump

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

What three are ways to export and import data in MySQL Workbench?

• A.SQL Data Export and Import Wizard
• B.Binary Data Export and Import Wizard
• C.Backup Data Export and Import Wizard
• D.Result Data Export and Import
• E.Data Modeling Import Export Wizard
• F.Table Data Export and Import Wizard