Free Oracle 1z0-320 Exam Dumps Questions & Answers

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.
Identify two reasons for this problem.

• A.  The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
• B.  All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
• C.  The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• D.  The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
• E.  The MASTER and SLAVE are grouped as one instance for monitoring.

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?

• A.  Components from one of the machines will be chosen as victim. Only one machine will provide service.
• B.  The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
• C.  The entire cluster will be shut down.
• D.  A MySQL Cluster backup process will be kick-started automatically.
• E.  All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.

Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

• A.  mysqlrplms
• B.  mysqlreplicate
• C.  mysqlrpladmin
• D.  mysqlrplcheck
• E.  mysqlreplicatems

Your customer runs several Oracle products and would like to reuse them. Identify four options that are certified to work with the MySQL Enterprise Edition features.

• A.  MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations.
• B.  MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup.
• C.  MySQL Enterprise Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys.
• D.  MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.
• E.  MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting.
• F.  MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.

When creating a FOREIGN KEY constraint, what SQL variable must be specified?

• A.  the SET_FOREIGN_KEY variable in the my.cnf file
• B.  a REFERENCE in the child table to the parent table
• C.  UNIQUE PRIMARY KEY values for both child and parent tables
• D.  a TRIGGER on the child table for cascading DELETE statements
• E.  an INDEX on the FOREIGN KEY