Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 21:

  You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY.

  What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

  A. ANALYZE TABLE INVENTORY;
  B. mysqlcheck INVENTORY
  C. mysqldump INVENTORY
  D. OPTIMIZE TABLE INVENTORY;
  D. OPTIMIZE TABLE INVENTORY;

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

• Question 22:

  You execute the following statement SELECT NULL=NULL;

  What is the result?

  B. 1
  C. TRUE
  D. FALSE
  E. NULL
  D. FALSE

• Question 23:

  You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

  A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
  B. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.
  C. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
  D. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.
  E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.
  C. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.

• Question 24:

  Your customer has provided you with the following server specifications: 64-bit, Oracle Linux 6, 24 Numa CPU cores, 48 GB memory, and sequential write-optimized drives in the /var/lib/seq-write directory. The customer wants you to optimize their MySQL 5.7.10 installation for the server resources available.

  Identify three correct configurations for this server setup.

  A. mysql_numa_interleave=ON, innodb_buffer_pool_instances=8, innodb_log_file_size=24G
  B. innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8
  C. innodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1
  D. plugin_load= "thread_pool.so", innodb_page_cleaners=12, innodb_log_group_home_dir=/var/lib/seq-write
  E. innodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G
  F. innodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G
  A. mysql_numa_interleave=ON, innodb_buffer_pool_instances=8, innodb_log_file_size=24G
  B. innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8
  E. innodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G

• Question 25:

  MySQL is installed on a Linux server and has the following configuration:

  [mysqld] User=mysql Datadir=/data/mysql

  Which two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?

  A. Create user by using CREATE USER `newuser' @'localhost' SET PASSWORD AS `Sh@256Pa33';
  B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
  C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
  D. Create user by using CREATE USER `newuser'@'localhost' IDENTIFIED WITH `Sh@256Pa33';
  B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.
  D. Create user by using CREATE USER `newuser'@'localhost' IDENTIFIED WITH `Sh@256Pa33';

  ---

  Reference: https://dev.mysql.com/doc/refman/5.6/en/sha256-pluggable-authentication.html

• Question 26:

  You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.

  Which two options should you include in the MySQL configuration file?

  A. audit_log_permanent=ON
  B. audit-log=FORCE_PLUS_PERMANENT
  C. plugin-load=audit_log.so
  D. plugin-audit=ON, ALWAYS
  E. LOAD PLUGIN=AUDIT_LOG
  A. audit_log_permanent=ON
  B. audit-log=FORCE_PLUS_PERMANENT

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html

• Question 27:

  You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.

  Which two options should you add to the mysqlbackup to achieve the restoration of the database?

  A. --uncompress-and-apply-log
  B. --apply-log-and-copy-back
  C. --copy-back-and-apply-log
  D. --uncompress
  E. --decompress
  C. --copy-back-and-apply-log
  D. --uncompress

  ---

  Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/mysqlbackup.restore.html

• Question 28:

  Which two methods can change password expiration for a database user account? (Choose two.)

  A. Create a new database user account with an explicit password expiration time
  B. Use an ALTER USER command to change the password expiration
  C. Use the SET GLOBAL command to update the default password expiration time
  D. Update the my.cnf configuration to include default_password_lifetime=100 and restart the server
  B. Use an ALTER USER command to change the password expiration

  ---

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4003.htm

• Question 29:

  Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply.

  A. You forgot to create the correct SSL/TLC certificate during the setup process.
  B. The `opc' user can be used to access MySQL only with the created SSH-Key.
  C. Only `root' is allowed to access from non-localhost.
  D. The MySQL instance is still in the "Creation" process.
  E. You forgot to enable port 3306.
  C. Only `root' is allowed to access from non-localhost.
  E. You forgot to enable port 3306.

• Question 30:

  Which statement will display the status of the partitioning plug-in?

  A. SHOW STATUS PLUGINS WHERE Name= `PARTITIONING';
  B. SHOW PLUGINS WHERE Name= `partition';
  C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= `partition';
  D. USE SYS SCHEMA; SHOW PLUGINS STATUS;
  C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= `partition';

  ---

  Reference: https://dev.mysql.com/doc/refman/5.7/en/partitioning.html