Free Oracle 1z0-320 Exam Dumps Questions & Answers

Identify three features of MySQL Enterprise Backup.

• A.  You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements.
• B.  You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online.
• C.  You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
• D.  You can back up data that has changed since the last backup with incremental backup.
• E.  You can edit the output file produced by a MySQL Enterprise Backup.

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing.
The binlog size keeps growing. Identify two methods to fix the issue.

• A.  Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• B.  Delete all binlog files manually on the file system to release storage spaces.
• C.  Execute the PURGE BINARY LOGS statement without argument.
• D.  To safely purge binary log files, perform the following steps:1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up-to-date, this is the last log file on the list.4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)5. Purge all log files up to but not including the target file by using the PURGE BINARY LOGS statement.
• E.  On the Master server, disable binlog by removing the - - log -bin option.

A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A.  The customer account might have reached its compute quota.
• B.  The customer reached the database instance limit of 32.
• C.  The customer does not have proper user rights.
• D.  The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.

MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

• A.  The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.
• B.  Use MySQL Router with the following
  configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
  failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.
• C.  Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
  [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]
• D.  Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
  /var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
  7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001

Identify two features of MySQL Enterprise Firewall.

• A.  You can automatically delete a user if the user breaks your firewall.
• B.  You can block out potential threats by setting up a preapproved whitelist.
• C.  You can modify a request with a SQL statement substitution.
• D.  You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.
• E.  You set the firewall per database.