Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 81:

  Identify two features of MySQL Enterprise Firewall.

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

  ---

  Reference: https://www.mysql.com/products/enterprise/firewall/features.html

• Question 82:

  You have the following mysqlbackup-inc.cnf config file:

  

  Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

  A. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 -user=mysqlbackup -password -with-timestamp backup
  B. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf -port=3306 -host=127.0.0.1 -user=mysqlbackup -password -incremental backup-to-image
  C. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf -port=3306 -host=127.0.0.1 -user=mysqlbackup -password backup-incremental
  D. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf -port=3306 -host=127.0.0.1 -user=mysqlbackup -password backup-to-incremental
  E. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf -port=3306 -host=127.0.0.1 -user=mysqlbackup -password incremental
  B. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf -port=3306 -host=127.0.0.1 -user=mysqlbackup -password -incremental backup-to-image

  ---

  Reference https://downloads.mysql.com/docs/mysql-enterprise-backup-3.8-en.a4.pdf

• Question 83:

  Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

  A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.
  B. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the KEY VAULT file.
  C. Both MyISAM and InnoDB table can be encrypted by setting the keyring_engine =ALL variable in the MySQL configuration file.
  D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
  A. TDE supports at-rest encryption for InnoDB tables stored in file-per-table tablespaces.

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html

• Question 84:

  The MySQL Enterprise Monitor Agent requires a user configured in each MySQL instance that is being monitored with suitable privileges to collect information about the server. Identify the correct statement.

  A. MySQL Enterprise Monitor creates the required users automatically.
  B. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.
  C. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.
  D. The super privilege is required when creating and populating the inventory table, as well as running statements such as SHOW MASTER LOGS OR SHOW ENGINE INNODB STATUS.
  D. The super privilege is required when creating and populating the inventory table, as well as running statements such as SHOW MASTER LOGS OR SHOW ENGINE INNODB STATUS.

  ---

  Reference: https://dev.mysql.com/doc/mysql-monitor/4.0/en/mem-agent-rights.html

• Question 85:

  The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server: CREATE USER `SQL_admin'@'%' IDENTIFIED WITH authentication_windows AS `joe, henry, "Power Users"';

  Which two statements are valid?

  A. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL.
  B. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.
  C. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory.
  D. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.
  E. Logins are granted only if the user's client application and the corresponding MySQL instance are on the same IP address.
  B. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.
  D. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.

• Question 86:

  You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

  A. CREATE TABLE City_part AS SELECT * FROM City;
  B. CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
  C. CREATE TABLE City_part LIKE City;
  D. INSERT INTO City_part SELECT * FROM City;
  A. CREATE TABLE City_part AS SELECT * FROM City;

• Question 87:

  Which statement would create an index by using the first 10 characters of the name column in the customer table (assuming that name is a nonbinary string type?)

  A. CREATE SUB INDEX part_of_name ON (customer, name, 10);
  B. CREATE INDEX (10) ON (customer.name);
  C. CREATE INDEX part_of_name ON customer (name(10));
  D. CREATE PARTIAL INDEX part-of_name ON customer (name, 10);
  E. CREATE INDEX part_of_name ON customer.name LIMIT 10 CHAR;
  C. CREATE INDEX part_of_name ON customer (name(10));

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/create-index.html

• Question 88:

  The following backup command is executed:

  mysqlbackup -–defaults-file=config/mysqlbackup.cnf -–compress -–port=3306 -–host=127.0.0.1 -–user=mysqlbackup A. Run a mysql command as follows.mysqlbackup will continue. mysql> resume mysqlbackup;
  B. Log in to the MySQL server and identify the processid, which issues GLOBAL READ LOCK. Connect the mysql session and terminate the session for the identified "processed" .mysqlbackup will continue
  C. An external program or manual work is to be executed to complete the backup and the marker file "/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally. After the file is removed, mysqlbackup will continue
  D. Issue a SIGTERM to the mysqlbackup process.mysqlbackup will continue
  E. Run a mysql command as follows,.mysqlbackup will continue. mysql>UNLOCK TABLES;

  C. An external program or manual work is to be executed to complete the backup and the marker file "/home/mysql/backup/full/mybackup/datadir/ibbackup_suspended' should be removed intentionally. After the file is removed, mysqlbackup will continue

• Question 89:

  What command should be used to execute a stored procedure named run_daily_report with the parameter 2016/12/31?

  A. SELECT SP run_daily_report (`2016/12/31') from mysql.procedures;
  B. CALL run_daily_report (`2016/12/31');
  C. EXECUTE PROC run_daily_report INCLUDE PARAMETER (`2016/12/31');
  D. UPDATE PROCEDURE run_daily_report WHERE VARIABLE = ("2016/12/31');
  B. CALL run_daily_report (`2016/12/31');

  ---

  Reference: https://dev.mysql.com/doc/refman/8.0/en/call.html

• Question 90:

  Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available?

  A. Deploying MySQL Agent on supported target operating system
  B. Tracing import and export with mysqldump
  C. Monitoring the availability of the MySQL instance
  D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings
  E. Starting and Stopping the MySQL Instance
  F. Analyzing executed MySQL queries
  A. Deploying MySQL Agent on supported target operating system
  B. Tracing import and export with mysqldump
  D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings