Free Oracle 1z0-320 Exam Dumps Questions & Answers

When creating a FOREIGN KEY constraint, what SQL variable must be specified?

• A.  a REFERENCE in the child table to the parent table
• B.  the SET_FOREIGN_KEY variable in the my.cnf file
• C.  a TRIGGER on the child table for cascading DELETE statements
• D.  UNIQUE PRIMARY KEY values for both child and parent tables
• E.  an INDEX on the FOREIGN KEY

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on three machines to a connected Storage NFS?

• A.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4.
  Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
• B.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
• C.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
• D.  1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.

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 LIKE City;
• B.  CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;
• C.  CREATE TABLE City_part AS SELECT * FROM City;
• D.  INSERT INTO City_part SELECT * FROM City;

The MySQL server looks for option files in standard locations. The server might read multiple files from different locations. For a Linux installation, which two methods would you use to view the options file lookup locations, the order in which they are read, and groups?

• A.  $ mysqld --help
• B.  SHOW GLOBAL VARIABLES;
• C.  $ mysqld - -help - -verbose | grep-A1 "Default options"
• D.  $ mysql - - print-defaults

Identify three characteristics of the JSON data type.

• A.  It is based on the TEXT data type.
• B.  it supports indexing directly against the JSON-defined column.
• C.  It validates the JSON syntax on insert or merge.
• D.  A set of SQL functions substantially support the SQL utilization of the data type.
• E.  Key or array references enable quick read-access to look up document elements directly.
• F.  Comparisons of JSON values are not case-sensitive.