1z1-320 무료 덤프문제 온라인 액세스

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.Key or array references enable quick read-access to look up document elements directly.
• E.it supports indexing directly against the JSON-defined column.
• F.Comparisons of JSON values are not case-sensitive.

Your customer wants you to install and configure MySQL on the customer's Oracle Linux 6 server with tarball binaries in the /app/mysql1/directory, where the bin directory is found at /app/mysql/bin and a data directory at /app/data.
What are two correct and required server configurations, excluding redundant configuration entries, to build a MySQL instance supporting your customer's requirement?

• A.The configuration basedir=/app/mysql is needed.
• B.The configuration log-bin=/app/data is needed.
• C.The configuration datadir=/app/mysql/data is needed.
• D.The configuration datadir=/app/data is needed.
• E.The configuration innodb_log_group_home_dir=/datadir is needed.
• F.The configuration basedir=/app/mysql/bin is needed.

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.Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.
• B.Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';
• 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.Create a new database user account with an explicit password expiration time
• B.Use the SET GLOBAL command to update the default password expiration time
• C.Use an ALTER USER command to change the password expiration
• D.Update the my.cnf configuration to include default_password_lifetime=100 and restart the server

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 Backup can send its backups directly to Oracle Secure Backup.
• C.MySQL Server's configuration can be saved by Oracle Enterprise Manager so that configuration changes can be tracked.
• D.MySQL Enterprise Encryption uses Cloud Key Vault's access to OpenSSL to create encrypted keys.
• E.MySQL Server can be hosted using Oracle VM for hard-partitioned virtualization installations.
• F.MySQL Enterprise Firewall uses Oracle Database Firewall to block intrusive users and queries.