Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 61:

  Which two statements are true about MySQL Enterprise Firewall?

  A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
  B. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
  C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
  D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
  E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
  F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
  D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
  E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

  ---

  Reference: https://planet.mysql.com/entry/?id=5989808

• Question 62:

  Which query will find rows in a table that have no counterpart in another table?

  A. SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;
  B. SELECT left_tbl.* FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.id WHERE right_tbl.id IS NULL;
  C. SELECT t1.name, t2.name2 FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
  D. SELECT t1.name, t2.name2 FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
  B. SELECT left_tbl.* FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.id WHERE right_tbl.id IS NULL;

  ---

  Reference: https://stackoverflow.com/questions/18000564/mysql-query-for-finding-rows-that-are-in-one-table-but-not-another

• Question 63:

  You have a backup image file that is backed up using MySQL Enterprise Backup with the - - compress option:

  /home/mysql/backup/full/mybackup/myimage.img

  mysqlbackup.cnf is shown as follows:

  [mysqlbackup]

  backup-dir=/home/mysql/backup/full/mybackup

  backup-image=/home/mysql/backup/full/mybackup/myimage.img

  You are required to perform a database restore to a new machine to provision the database.

  Which command can provision the new database in the datadir as /home/mysql/data/MEB?

  A. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB image-to-dir-and-apply-log
  B. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB apply-log-and-copy-back
  C. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB copy-back-and-apply-log
  D. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB restore-and-apply-log
  E. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB image-to-dir
  B. #mysqlbackup - -defaults-file= config/mysqlbackup.cnf - -port=3306 - -host= 127.0.0.1\ - - user= mysqlbackup - -password - - uncompress - - backup-dir=/home/mysql/backup/full/myrestore\ - -datadir=/home/mysql/data/MEB apply-log-and-copy-back

• Question 64:

  The replication setup for Master and Slave MySQL 5.6 instances is configured and running correctly without using Global Transaction ID (GTID). You are required to perform a replication change to implement GTID for the MASTER and SLAVE configuration.

  Which two steps would you perform?

  A. Restart MySQL (MASTER and SLAVE) with the following options enabled: - - gtid_mode=ON - - log-bin - -log-slave-updates - - enforce-gtid-consistency
  B. On the SLAVE, alter the mysql master connection setting with: > CHANGE MASTER TO >MASTER_HOST = host, >MASTER_PORT = port, >MASTER_USER = user, >MASTER_PASSWORD= password, >MASTER_AUTO_POSITION=1
  C. On the SLAVE, alter the mysql master connection setting with: > ALTER system CHANGE MASTER TO >MASTER_HOST = host, >MASTER_PORT = port, >MASTER_USER = user, >MASTER_PASSWORD= password, >MASTER_AUTO_POSITION=1
  D. Enable GTID by executing the following on MASTER and SLAVE: >set global GTID_ENALBED=on;
  E. Execute the following on SLAVE to enable GTID: >start slave io_thread - -gtid-mode=on;
  A. Restart MySQL (MASTER and SLAVE) with the following options enabled: - - gtid_mode=ON - - log-bin - -log-slave-updates - - enforce-gtid-consistency
  B. On the SLAVE, alter the mysql master connection setting with: > CHANGE MASTER TO >MASTER_HOST = host, >MASTER_PORT = port, >MASTER_USER = user, >MASTER_PASSWORD= password, >MASTER_AUTO_POSITION=1

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html

• Question 65:

  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. Execute the PURGE BINARY LOGS statement without argument.
  B. On the Master server, disable binlog by removing the - - log 璪in option.
  C. Delete all binlog files manually on the file system to release storage spaces.
  D. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
  E. 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.
  D. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
  E. 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.

• Question 66:

  You want to prevent your users from using a specific list of passwords. How would you implement this on your system?

  A. Specify the nonusable passwords via MySQL Enterprise Audit
  B. Store values in the mysql.user_invalid_passwords table
  C. Manually store the values in a file and use SHA-256 to check against the mysql.user table
  D. You cannot save a list of nonusable passwords in MySQL
  E. Store values in a plain-text file set by using the validate_password_dictionary_file command
  F. Set validate_password_dictionary_file=pass_dict.txt and store the nonusable passwords in the pass_dict.txt file in your data directory
  F. Set validate_password_dictionary_file=pass_dict.txt and store the nonusable passwords in the pass_dict.txt file in your data directory

• Question 67:

  A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

  A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server
  B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor
  C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server
  D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server
  B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor

• Question 68:

  You create two database tables as shown by the following CREATE TABLE statements:

  CREATE TABLE parent (

  parent_id INT,

  name_first VARCHAR(30),

  name_last VARCHAR(30),

  PRIMARY KEY (parent_id)

  );

  CREATE TABLE child (

  child_id INT,

  parent_id INT,

  name_first VARCHAR(30),

  name_last VARCHAR(30),

  PRIMARY KEY (child_id)

  );

  After populating both tables with data, which statement would produce an output of only the parents' first and last names and the first and last names of the related children?

  A. SELECT * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id);
  B. SELECT p1.name_first, p1.name_last, c1.name_first, c1.name_last FROM parent p1 LEFT JOIN child c1 ON (c1.parent_id=p1.parent_id);
  C. SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id;
  D. SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL;
  C. SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id;

• Question 69:

  You need to change the password level for a test system. Which two options enable to change this level before you create new test user/passwords?

  A. SET GLOBAL validate_password_policy='new level';
  B. SET GLOBAL force_password_complex_policy=0;
  C. Add validate_password_policy='new level' in the [mysql] section of the MySQL configuration file.
  D. Add validate_password='new level' in the [security] section of the MySQL configuration file.
  A. SET GLOBAL validate_password_policy='new level';
  D. Add validate_password='new level' in the [security] section of the MySQL configuration file.

  ---

  Reference: https://qiita.com/liubin/items/3722ab10a73154863bd4

• Question 70:

  You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

  A. MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL
  B. For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server.
  C. Use UPDATE performance_schema.setup_consumers SET enabled = `YES' WHERE name='statements_digest';
  D. Use UPDATE performance_schema.setup_consumers SET enabled = `NO' WHERE name = `statements_digest';
  C. Use UPDATE performance_schema.setup_consumers SET enabled = `YES' WHERE name='statements_digest';