1Z0-920 by Oracle Valid Free Exam Practice Test

Question 1

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

Correct Answer: B,E

Question 2

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

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

Correct Answer: A

Question 3

Which three are levels in which MySQL Enterprise Monitor provides access control?

A. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration B. Asset visibility: the rights to access data collected from hosts or MySQL instances C. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services D. Specific data access: the rights to view specific types of potentially sensitive data E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

Correct Answer: A,B,D

Question 4

Which three statements are true about MySQL Enterprise Backup?

A. It performs hot or warm backups. B. It provides the ability to create incremental backups. C. It cannot back up encrypted tablespaces. D. It performs logical backups. E. It enables you to take non-locking backups.

Correct Answer: B,D,E

Question 5

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

A. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance. B. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance. C. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key. D. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.

Correct Answer: C

Question 6

Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

A. Your instance does not have a public IP address, so you cannot connect with a public subnet. B. You can connect directly to the VCN without a define subnet. C. You can connect directly to an instance over the internet, without a public IP address. D. You must have an IPSec VPN to connect to an Oracle Linux instance. E. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.

Correct Answer: B,C

Question 7

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

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

Correct Answer: A,C,D,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle MySQL 2019 Implementation Essentials - 1Z0-920 Exam Practice Test