Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 41:

  You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?

  A. Sort the "Exec" column and check for SQL queries with high QRTi values.
  B. Sort the "Exec" column and check for SQL queries with low QRTi values.
  C. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)
  D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)
  C. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)

• Question 42:

  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 = 7001 mode=replication destinations=master:3306, slave:3306 The Java application can connect to bind_port=7001
  C. Use MySQL Router with the following configuration: [DEFAULT] logging_folder=/var/log/mysqlrouter [logger] level=INFO [routing: failover] bind_port = 7001 mode=read-write destinations= master:3306, slave:3306 The Java application can connect to bind_port=7001.
  D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL as jdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ... [/[database]] [? propertyName=propertyValue1 [andpropertyName2-propertyValue2]...]
  D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL as jdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ... [/[database]] [? propertyName=propertyValue1 [andpropertyName2-propertyValue2]...]

• Question 43:

  When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period. There is no update/ alternation to tables with non-InnoDB storage engines.

  Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

  A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
  B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.
  C. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
  D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.
  E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.
  B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.
  E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

  ---

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.10-en/mysql-enterprise-backup-3.10-en.pdf (page 62)

• Question 44:

  Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

  A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent
  E. A browser-based wizard to remotely deploy the MySQL Monitor Agent
  A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
  C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

• Question 45:

  A keyfile has been generated as follows: # openssl rand 32 -hex >keyfile # cat keyfile 6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b

  You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.

  Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

  A. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile - -backup-dir=/var/tmp/backup backup-to-image
  B. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup
  C. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image
  D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile - -backup-dir=/var/tmp/backup backup-to-image
  E. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup ?timestamp backup
  D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile - -backup-dir=/var/tmp/backup backup-to-image

  ---

  Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/meb-encryption.html

• Question 46:

  Identify three levels in which MySQL Enterprise Monitor provides access control.

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

  ---

  Reference: https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-acl-users-roles-ref.html

• Question 47:

  Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

  A. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client
  B. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench
  C. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server
  D. Port 22/tcp [SSH], when using TCP/IP over SSH
  B. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench
  D. Port 22/tcp [SSH], when using TCP/IP over SSH

• Question 48:

  You want to monitor SQL statements, which are executed on the MySQL server, in MySQL Enterprise Monitor (MEM). Select three possible ways.

  A. Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager.
  B. Route MySQL SQL statements through a MySQL Monitor Proxy.
  C. Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later.
  D. Configure MySQL to replicate data via the MySQL binlog to MEM.
  E. Configure the MySQL Router to send normalized SQL statements to MEM.
  A. Configure a MySQL Connector that sends information directly to MySQL Enterprise Service Manager.
  C. Configure the Performance Schema statement digests with MySQL Server 5.6.14 or later.
  D. Configure MySQL to replicate data via the MySQL binlog to MEM.

• Question 49:

  The user `fwuser'@'localhost' was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed commands:

  

  You want to clear the account whitelist for the `fwuser'@'localhost' user. Which statement would you run to accomplish this?

  A. CALL mysql.sp_reload_firewall_rules (`fwuser@localhost');
  B. SET mysql.sp_set_firewall_mode= `RECORDING';
  C. CALL mysql.sp_set_firewall_mode (`fwuser@localhost', `CLEAR');
  D. DELETE TABLE INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST;
  C. CALL mysql.sp_set_firewall_mode (`fwuser@localhost', `CLEAR');

  ---

  Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.6/en/firewall-routines.html

• Question 50:

  The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

  A. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
  B. Oracle MySQL Enterprise Tools and Plugins are available as optional services (installation Feature Pack I/II).
  C. MySQL CS is installed based on the Oracle Flexible Architecture Standard.
  D. MySQL CS is based on the MySQL Enterprise Product Suite.
  E. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).
  F. MySQL CS configuration can be changed in /etc/my.cnf.
  B. Oracle MySQL Enterprise Tools and Plugins are available as optional services (installation Feature Pack I/II).
  D. MySQL CS is based on the MySQL Enterprise Product Suite.
  F. MySQL CS configuration can be changed in /etc/my.cnf.