Free Oracle 1Z0-920 Exam Dumps Questions & Answers

Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

• A.Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
• B.Increasing the storage capacity so that the database can store more data to scale.
• C.Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
• D.Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
• E.Allocating more CPU to the database instance to improve throughput performance.

Which three statements are true about MySQL Enterprise Backup?

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

The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?
A)

B)

C)

D)

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

Which is true about inserting an additional line in a single document stored in MySQL document store?

• A.The path specified must be an array position past the end of an array using the JSON_POSITION statement.
• B.You cannot insert a single line, you have to replace the entire document with a new document.
• C.You specify the new element's position in the JSON_ARRAY_INSERT statement.
• D.Any new lines can only be inserted at the end of the document.

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

• A.Use the provided private key for authentication.
• B.Convert the private key to ppk format first and use the new private key for authentication.
• C.Open Port 22 on your OCI Instance and configure Putty with the ssh private key.
• D.Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.