Free Oracle 1Z0-920 Exam Dumps Questions & Answers

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

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

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

The slave connects to the master and asks for updated records. What command was issued for this to happen?

• A.  RUN SLAVE
• B.  SLAVE RUN
• C.  START RUN SLAVE
• D.  SLAVE START
• E.  START SLAVE

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

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

Which query will find rows in a table that have no counterpart in another table?

• A.  SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
• B.  SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
• C.  SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
• D.  SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;