Oracle Oracle Certifications 1Z0-920 Questions & Answers

• Question 11:

  Which three are requirements for MySQL Group Replication (GR)?

  A. Data to be replicated must be stored in the InnoDB transactional storage engine.

  B. The use of global transaction identifiers is required.

  C. Primary keys are required on every replicated table.

  D. GR only works with MySQL versions 8.0.12 or higher.

  E. The binary log format must be set to mixed.

  F. The minimum number of required nodes for achieving a consensus is two.

  Correct Answer: ACE

  https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html

• Question 12:

  When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?

  A. Flash-archive recovery area

  B. Cloud storage only

  C. Cloud tape library

  D. Both Cloud storage and local storage

  Correct Answer: BD

  Backup Destination--select how backups are to be configured: Both Cloud Storage and Local Storage--backups are configured to be created automatically and stored both on local storage and on an Oracle Storage Cloud Service container. None--backups are not configured. Cloud Storage Only--backups are configured to be created automatically and stored in an Oracle Storage Cloud Service container. No local backup is created for this option. If you select Cloud Storage Only or Both Cloud Storage and Local Storage, the Cloud Storage Container, User Name and Password fields are displayed: https://docs.oracle.com/cloud/latest/mysql-cloud/UOMCS/GUID-D03FE523-AD8D-4C53-935CD5D6513D2A24.htm

• Question 13:

  Which two deployment architectures could you use for scaling-out database reads?

  A. Implementing a three-node, single-primary InnoDB Cluster.

  B. Edit the configuration file and increase the value for parallel_read_workers and reboot the server

  C. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

  D. Altering the storage engine for all tables to memory to increase performance.

  E. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

  Correct Answer: AD

• Question 14:

  Which three statements describe MySQL Enterprise Backup?

  A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

  B. MySQL Enterprise Backup provides the point-in-time recovery functionality.

  C. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

  D. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

  E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

  Correct Answer: BDE

• Question 15:

  You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

  A. You can expect an outage of your MySQL OCI instance during the planned time..

  B. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

  C. You need to agree to the maintenance windows. If not, you are not affected by the outage.

  D. There are no maintenance operations planned. You need to do them manually.

  Correct Answer: A

• Question 16:

  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.

  Correct Answer: DE

• Question 17:

  Which two are advantages of using Document Store in MySQL?

  A. MySQL provides a NoSQL API to access the document store

  B. MySQL can store XML as a schema-less database

  C. MySQL is a document database allowing PDF and Word documents

  D. MySQL provides a native data type to index PDF documents

  E. MySQL provides a native data type to store JSON data as a document

  Correct Answer: AB

  https://www.mysql.com/products/enterprise/document_store.html

• Question 18:

  You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running. You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave. Which two are possible reasons for this problem?

  A. The SLAVE and MASTER instances are started with the same configured value for the option - monitor_server_uuid.

  B. The MASTER and SLAVE are grouped as one instance for monitoring.

  C. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

  D. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

  E. All the MySQL instances (Master and Slave) have the same server_uuid in /auto.cnf.

  Correct Answer: BD

• Question 19:

  What SQL keyword must be specified when creating a foreign key constraint?

  A. a TRIGGER on the child table for cascading delete statements

  B. a REFERENCES in the child table to the parent table

  C. unique PRIMARY key values for both child and parent tables

  D. the SET_FOREGIN variable in the my .cnf file

  E. an index on the foreign key

  Correct Answer: A

• Question 20:

  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. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D