Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 91:

  A MySQL 5.7 is monitored via 3306 without a MySQL agent (agentless installation). Which two options are not available in such a setup in the MEM GUI?

  A. Network-related information and network characteristics
  B. Security-related advisors warning (for example, password warnings and firewall warnings)
  C. MySQL Query Analysis data.
  D. Disk usage and disk characteristics including disk advisors warnings
  E. MySQL Replication monitoring
  A. Network-related information and network characteristics
  B. Security-related advisors warning (for example, password warnings and firewall warnings)

• Question 92:

  Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability.

  A. the MySQL memcached plug-in
  B. the MySQL PAM Authentication plug-in
  C. the MySQL Thread Pool plug-in
  D. the MySQL No-Login Authentication plug-in
  E. the MySQL Firewall plug-in
  F. the MySQL Semisynchronous replication plug-in
  B. the MySQL PAM Authentication plug-in

• Question 93:

  The user `OS-user'@'localhost' was created to monitor connections and shut down the server, and was granted the following privileges: GRANT PROCESS, SHUTDOWN ON *.* to `OS-user'@'localhost';

  Identify three commands that the OS-user can execute.

  A. SHOW STATUS;
  B. SHUTDOWN;
  C. SHOW BINLOG EVENTS;
  D. SHOW PROCESSLIST;
  E. KILL PROCESS;
  A. SHOW STATUS;
  B. SHUTDOWN;
  E. KILL PROCESS;

• Question 94:

  You have three machines with MySQL Databases running on Linux platform.

  Which backup procedures would allow online and remote backup of the MySQL Database on three machines to a connected Storage NFS?

  A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on machine which is used to start the backup. 3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving --hosts=machine1:port1, machine2:port2, machine3:port3. 4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
  B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on all three machines. 3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir. 4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
  C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on the machine that is used to start the backup. 3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines. 4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
  D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore. 3. Startup MySQL backup from MySQL Workbench to back up the three databases. 4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
  B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access. 2. Install MySQL Enterprise Backup on all three machines. 3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir. 4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

• Question 95:

  Which two architecture options can provide Active/Active Master configuration for the MySQL Database?

  A. Execute the following on the 2x MySQL Server Instances mysql> ALTER REPLICATION set mode= active;
  B. Deploy MySQL Cluster on the following machines: Machine 1: MySQL Node+ MySQL Management Node Machine 2: MySQL Node+ MySQL Management Node Machine 3: Data Node Machine 4: Data Node Application can access MySQL Node on Machine 1 or Machine 2 for Active/Active Configuration.
  C. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance. MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2 Application A connecting to MySQL Database Instance 1 for schema db1 Application B connecting to MySQL Database Instance 2 for schema db2
  D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.
  E. 2x MySQL Server Instances should be deployed on two machines with shared NFS volume. Datadir points to the shared folder. Applications can access either one of the MySQL Servers for the same set of data.
  C. Configure MySQL Replication for two MySQL Database instances with circular Replication Topology, where two different applications with each using different database schemas connecting to a specified MySQL Database Instance. MySQL Database Instance1 < -----Replication---> MySQL Database Instance 2 Application A connecting to MySQL Database Instance 1 for schema db1 Application B connecting to MySQL Database Instance 2 for schema db2
  D. Configure MySQL Replication between two MySQL Database instances and setting Replication mode = active.