Free Oracle 1z0-320 Exam Dumps Questions & Answers

You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.
Which two preventative actions should you take if your number of monitored MySQL instances has changed?

• A.Increase the disk space with at least 10% of the database size.
• B.Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (--JvmMs/-Xms and -JvmMx/-Xmx).
• C.Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).
• D.Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx,
  /etc/fstab.

A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances.
What could be the problem?

• A.The customer account might have reached its compute quota.
• B.The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.
• C.The customer reached the database instance limit of 32.
• D.The customer does not have proper user rights.

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

Which two methods can change password expiration for a database user account? (Choose two.)

• A.Update the my.cnf configuration to include default_password_lifetime=100 and restart the server
• B.Create a new database user account with an explicit password expiration time
• C.Use an ALTER USER command to change the password expiration
• D.Use the SET GLOBAL command to update the default password expiration time

You execute the following statement SELECT NULL=NULL;
What is the result?

• A.0
• B.1
• C.TRUE
• D.NULL
• E.FALSE