Oracle 1Z0-320 Dumps PDF Syllabus

Question No. 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 installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.
• 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 a package of utilities that are used for maintenance and administration of MySQL servers. Downloadthe MySQL Utilities separately from www.mysql.com.

Question No. 2

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

• A. ALTER mysql.encryptionSET tde_status = 'YES';
• B. UPDATE TABLE SET ENCRYPTION = 'ON';
• C. ALTER TABLE ENCRYPTION = 'Y';
  D. ALTER INSTANCE ROTATE INNODB MASTER KEY;
  Answer: C
  
  

  https://scriptingmysql.wordpress.com/tag/mysql-enterprise-edition/

  https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html

  Question No. 3

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

  Answer: E

  
  

  Question No. 4

  Which four options are valid reasons for using a PRIMARY KEY in a table?

  • A. Eliminating the need for accessing thedatabase cache
  • B. Preventing duplicate keys
  • C. Maintaining a history of row insertions or updates
  • D. Automatic storage of data in a sorted order
  • E. Increasing performance when using SELECT statements
  • F. Auto-generating values via AUTO_INCREMENT
  • G. Exporting data faster with mysqldump

  Answer: B, E, F, G

  
  

  Question No. 5

  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. Email
  • B. SMS
  • C. Notification tab on the dashboard
  • D. Browser pop-ups
  • E. Direct support call from an Oracle representative

  Answer: A, B, C

  
  

  Question No. 6

  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 '[email protected]';
  • B. Add --default_authentication_plugin=sha256_password on the command line when you invoke theserver.
  • C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
  • D. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH '[email protected]';

  Answer: B, D

  
  

  Question No. 7

  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. mysqlslap
  • B. mysqlshow
  • C. mysqlimport
  • D. mysqlcheck
  • E. mysqladmin

  Answer: A

  
  

  Question No. 8

  MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

  • A. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.
  • B. Use MySQL Router with the following configuration:[DEFAULT]logging_folder= /var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port = 7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001
  • C. Use MySQL Router with the following configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.
  • D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ... [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]

  Answer: D

  
  
  Click Here For More Information: Oracle 1Z0-320 Dumps
  1Z0-320 Exam, 1Z0-320 questions, 1Z0-320 practice test, 1Z0-320 practice exam, 1Z0-320 dumps, 1Z0-320 Exam Dumps