1z0-320 by Oracle Actual Free Exam Questions And Answers

Question 1

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

A. a REFERENCE in the child table to the parent table

B. UNIQUE PRIMARY KEY values for both child and parent tables

C. a TRIGGER on the child table for cascading DELETE statements

D. the SET_FOREIGN_KEY variable in the my.cnf file

E. an INDEX on the FOREIGN KEY

Discussion 0

Correct Answer: C Vote an answer

Question 2

Which three statements are true about MySQL Enterprise Backup?

A. It cannot backup encrypted tablespaces.

B. It provides the ability to create incremental backups.

C. It enables you to take non-locking backups.

D. It performs logical backups.

E. It performs hot or warm backups.

Discussion 0

Correct Answer: B,C,D Vote an answer

Question 3

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. mysqlcheck

B. mysqlimport

C. mysqlslap

D. mysqladmin

E. mysqlshow

Discussion 0

Correct Answer: C Vote an answer

Question 4

MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics?

A. All MySQL (with MySQL Enterprise Monitor Proxy)

B. MySQL 5.6.14 Commercial (and later)

C. MySQL 5.5.9 (and later)

D. MySQL 5.7.9 Community (and later)

E. All MySQL (when MySQL connectors with Aggregator is used for the application)

Discussion 0

Correct Answer: A,B,C,D Vote an answer

Question 5

Identify two features of MySQL Enterprise Firewall.

A. You set the firewall per database.

B. You can block out potential threats by setting up a preapproved whitelist.

C. You can automatically delete a user if the user breaks your firewall.

D. You can modify a request with a SQL statement substitution.

E. You can set a recording mode to record incoming SQL statement to create a whitelist of permitted commands.

Discussion 0

Correct Answer: B,E Vote an answer

Question 6

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. SHOW GLOBAL VARIABLES;

B. $ mysqld - -help - -verbose | grep-A1 "Default options"

C. $ mysql - - print-defaults

D. $ mysqld --help

Discussion 0

Correct Answer: B,D Vote an answer

Question 7

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

A. Direct support call from an Oracle representative

B. SMS

C. Browser pop-ups

D. Email

E. Notification tab on the dashboard

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 8

Identify three characteristics of the JSON data type.

A. It is based on the TEXT data type.

B. It validates the JSON syntax on insert or merge.

C. A set of SQL functions substantially support the SQL utilization of the data type.

D. Comparisons of JSON values are not case-sensitive.

E. it supports indexing directly against the JSON-defined column.

F. Key or array references enable quick read-access to look up document elements directly.

Discussion 0

Correct Answer: B,E,F Vote an answer

Question 9

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to 10 per hour and the number of INSERTS to 4 per hour for user 'employee1' from MySQL Workbench by first selecting Server> Users and Privileges> employee1?

A. Set Max. Queries to 14 for 'employee1'.

B. Set Max. Connections to 14 for 'employee1'.

C. Set Max. Queries to 10 for 'employee1'.

D. Set Max Updates to 4 for 'employee1'.

E. Set Concurrent Connections to 14 for 'employee1'.

Discussion 0

Correct Answer: B,C Vote an answer

Question 10

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 under [mysqld] in the configuration file.

C. 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';

Discussion 0

Correct Answer: C,D Vote an answer

Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z0-320 Exam Practice Test

Contact Us

Useful Links

Latest Updated