Oracle 1Z0-320 Online Practice Questions and Exam Preparation

Oracle 1Z0-320 Online Questions & Answers

• Question 31:

  Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server?

  A. MySQL Enterprise Monitor
  B. MySQL Cluster Manager
  C. MySQL Enterprise Firewall
  D. MySQL Replication
  A. MySQL Enterprise Monitor
  C. MySQL Enterprise Firewall

  ---

  Reference: https://www.mysql.com/products/

• Question 32:

  Identify an example of creating an Enterprise Encryption function.

  A. SET@function = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len);
  B. VALIDATE FUNCTION create_asymmetric_priv_key WITH `openssl_udf.so';
  C. INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(`RSA', 1024));
  D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME `openssl_udf.so';
  D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME `openssl_udf.so';

  ---

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/enterprise-encryption-installation.html

• Question 33:

  You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.

  Which two preventative actions should you take if your number of monitored MySQL instances has changed?

  A. Increase the disk space with at least 10% of the database size.
  B. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx, /etc/fstab.
  C. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and -JvmMx/-Xmx).
  D. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
  A. Increase the disk space with at least 10% of the database size.
  D. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).

  ---

  Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html

• Question 34:

  After installing MySQL 5.7, you initialize the data directory with the - -initialize command. Identify two places in which you would find the root password.

  A. As root, execute the SHOW PASSWORD command by using the SHA-256 password encryption plug-in.
  B. The root password will be displayed on the screen via a [Warning] message.
  C. The root password will be inserted in the error log set by the - -log error= [file_name] variable.
  D. You will find it as a root_pw variable stored in the mysql.install table.
  E. The root password is not given and is blank. You must manually set the root password.
  A. As root, execute the SHOW PASSWORD command by using the SHA-256 password encryption plug-in.
  D. You will find it as a root_pw variable stored in the mysql.install table.

• Question 35:

  You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

  A. There are no maintenance operations planned. You need to do them manually.
  B. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
  C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
  D. You can expect an outage of your MySQL Cloud Service during the planned time.
  D. You can expect an outage of your MySQL Cloud Service during the planned time.

• Question 36:

  What are two key differences between the use of ndbd and ndbmtd?

  A. ndbd can be configured as ndbmtd by applying the option - - mtd.
  B. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id
  C. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.
  D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
  E. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.
  D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.
  E. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.

• Question 37:

  Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1.

  BEGIN;

  CREATE TABLE t1 (c1 INT);

  CREATE TABLE t2 (c1 INT);

  ROLLBACK;

  What is the result after issuing the ROLLBACK command?

  A. Both the tables, t1 and t2, are created.
  B. Only the t1 table is created.
  C. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
  D. Only the t2 table is created.
  A. Both the tables, t1 and t2, are created.

• Question 38:

  Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

  A. CREATE TEMPORARY TABLES
  B. REPLICATION CLIENT
  C. GRAND OPTION
  D. RELOAD
  E. INDEX
  A. CREATE TEMPORARY TABLES
  B. REPLICATION CLIENT
  D. RELOAD

  ---

  Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/mysqlbackup.privileges.html

• Question 39:

  Identify three features of MySQL Enterprise Backup.

  A. You can edit the output file produced by a MySQL Enterprise Backup.
  B. You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online.
  C. You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements.
  D. You can back up data that has changed since the last backup with incremental backup.
  E. You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
  A. You can edit the output file produced by a MySQL Enterprise Backup.
  D. You can back up data that has changed since the last backup with incremental backup.
  E. You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.

• Question 40:

  You are requested to export data from a set of the following tables in the database `world_x'. Tables (country, countryinfo, location)

  Which two options would allow you to export data as files?

  A. using MySQL Client and the - -dump option to dump the tables to files: # mysql –u -p –h -P -- dump world_x.country world_x.countryinfo world_x.location
  B. using MySQL Client and EXPORT TO to export data one by one: mysql>EXPORT world_x.country TO `/output/country.txt'; mysql>EXPORT world_x.countryinfo TO `/output/countryinfo.txt'; mysql>EXPORT world_x.location TO `/output/location.txt';
  C. using MySQL Client and SELECT ...INTO OUTFILE `' from to export data one by one: mysql>select * into outfile `/output/country.txt' from world_x.country; mysql>select * into outfile `/output/countryinfo.txt' from world_x.countryinfo; mysql>select * into outfile `/output/location.txt' from world_x.location;
  D. using mysqlexport to export multiple tables in a database in one command line: # mysqlexport –u- h -P -p world_x country countryinfo location> mydump.sql
  E. using mysqldump to dump multiple tables in a database in one command line: # mysqldump –u- h -P -p world_x country countryinfo location> mydump.sql
  C. using MySQL Client and SELECT ...INTO OUTFILE `' from to export data one by one: mysql>select * into outfile `/output/country.txt' from world_x.country; mysql>select * into outfile `/output/countryinfo.txt' from world_x.countryinfo; mysql>select * into outfile `/output/location.txt' from world_x.location;
  E. using mysqldump to dump multiple tables in a database in one command line: # mysqldump –u- h -P -p world_x country countryinfo location> mydump.sql