Free Oracle 1z1-320 Practice Test & Real Exam Questions, Page 1

Question #1

After the installation of the MySQL Server, you cannot find MySQL Utilities.
How would you correct the problem?

A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.

B. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

C. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.

D. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.

E. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.

Discussion 0

Correct Answer: B Vote an answer

Question #2

You have the following mysqlbackup-inc.cnf config file:

Which two commands allow MySQL Enterprise Backup to perform incremental backup based on the last full backup?

A. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --incremental backup-to-image

B. # mysqlbackup -defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-to-incremental

C. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password --with-timestamp backup

D. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password backup-incremental

E. # mysqlbackup --defaults-file=mysqlbackup-inc.cnf --port=3306 --host=127.0.0.1 --user=mysqlbackup
--password incremental

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #3

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

A. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication.

B. Convert the private key to ppk format first, and use the new private key for authentication.

C. Use the provided private key for authentication.

D. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

Discussion 0

Correct Answer: A Vote an answer

Question #4

A MySQL 5.7 is monitored via 3306 without a MySQL agent (agentless installation).
Which two options are not available in such a setup in the MEM GUI?

A. MySQL Query Analysis data.

B. Security-related advisors warning (for example, password warnings and firewall warnings)

C. Network-related information and network characteristics

D. MySQL Replication monitoring

E. Disk usage and disk characteristics including disk advisors warnings

Discussion 0

Correct Answer: B,C Vote an answer

Question #5

Your customer runs several Oracle products and would like to reuse them. Identify four options that are certified to work with the MySQL Enterprise Edition features.

A. MySQL Server can be monitored by Oracle Enterprise Manager both for performance and alerting.

B. MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.

C. MySQL Enterprise Backup can send its backups directly to Oracle Secure Backup.

D. MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations.

E. MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.

F. MySQL Enterprise Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys.

Discussion 0

Correct Answer: B,C,E,F Vote an answer

Question #6

Which three options describe the setup of MySQL High Availability solutions?

A. providing the Active/Passive setup of MySQL Server running on two machines with Shared Storage together with OS clustering to provide storage and Virtual IP failover

B. creating an NFS volume with multiple running MySQL Server Instances attaching the same NFS Volume with the same datadir

C. setting up Master and Slave with MySQL Semi-Sync Replication Plugin

D. setting up three machines configured as follows:Machine 1: Data Node and mysqld nodeMachine 2:
Data Node and mysqld nodeMachine 3: ndb_mgmd

E. Setting up three machines configured as follows:Machine A with 2 x Data NodesMachine B with 2 x mysqld nodeMachine C with 2 x ndb_mgmd node

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #7

You have configured MySQL Enterprise Transparent Data Encryption (TDE). What command would you use to encrypt a table?

A. ALTER TABLE <table> ENCRYPTION = 'Y';

B. UPDATE TABLE SET ENCRYPTION = 'ON';

C. ALTER INSTANCE ROTATE INNODB MASTER KEY;

D. ALTER mysql.encryption SET tde_status = 'YES';

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

You create two database tables as shown by the following CREATE TABLE statements:
CREATE TABLE parent (
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (parent_id)
);
CREATE TABLE child (
child_id INT,
parent_id INT,
name_first VARCHAR(30),
name_last VARCHAR(30),
PRIMARY KEY (child_id)
);
After populating both tables with data, which statement would produce an output of only the parents' first and last names and the first and last names of the related children?

A. SELECT name_first, name_last FROM parent, child LEFT JOIN parent_id WHERE parent_id = child_id;

B. SELECT * .name_first, *.name_last FROM BOTH parent, child WHERE parent_id IS EQUAL;

C. SELECT * FROM parent, child LEFT JOIN (child) ON (child.parent_id=parent.parent_id);

D. SELECT p1.name_first, p1.name_last, c1.name_first, c1.name_last FROM parent p1 LEFT JOIN child c1 ON (c1.parent_id=p1.parent_id);

Discussion 0

Correct Answer: A Vote an answer

Question #9

The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server:
CREATE USER 'SQL_admin'@'%' IDENTIFIED WITH authentication_windows AS 'joe, henry, "Power Users"'; Which two statements are valid?

A. Logins are granted only if the user's client application and the corresponding MySQL instance are on the same IP address.

B. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL.

C. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.

D. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory.

E. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.

Discussion 0

Correct Answer: C,E Vote an answer

Question #10

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. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.

B. The entire cluster will be shut down.

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. Components from one of the machines will be chosen as victim. Only one machine will provide service.

Discussion 0

Correct Answer: D Vote an answer

Free Oracle 1z1-320 Practice Test & Real Exam Questions

Download Free Oracle 1z1-320 Demo