Free Oracle 1z1-320 Exam Dumps Questions & Answers

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

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

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?

• A.  Components from one of the machines will be chosen as victim. Only one machine will provide service.
• B.  All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.
• C.  A MySQL Cluster backup process will be kick-started automatically.
• D.  The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
• E.  The entire cluster will be shut down.

When working with the Linux operating system on a database cloud instance (non-RAC), which user accounts are available for database and non-database administration?

• A.  admin, ora-cloud, and oracle
• B.  cloud-admin, oracle, and root
• C.  root, opc-administrator, and oracle through sudo
• D.  administrator, opc, and oracle
• E.  opc, oracle, and root (through sudo)

A MySQL installation has the following required architecture components: client programs, MySQL utilities, and MySQL Server.
Which client program would you use to emulate client load?

• A.  mysqlimport
• B.  mysqladmin
• C.  mysqlslap
• D.  mysqlshow
• E.  mysqlcheck

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 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
• B.  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.
• C.  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.
• D.  MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.
• E.  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.