仕事や学業でまとまった学習時間が取りにくい方こそ、JPNTestの1z1-320対策教材が役立ちます。Oracle MySQL Cloud Service 2018 Implementation Essentialsの出題傾向を分析した95の練習問題に絞って学習できるため、限られた期間でも効率的に実力を伸ばせます。

Oracle 1z1-320 試験概要:

Oracle 1z1-320 試験シラバストピック:

1z1-320試験のFAQ

Oracle MySQL Cloud Service 2018 Implementation Essentials 認定 1z1-320 試験問題：

問題 #1

You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

A. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.
B. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
C. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
D. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.
E. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.

問題 #2

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Identify two reasons for this problem.

A. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.
B. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.
C. The MASTER and SLAVE are grouped as one instance for monitoring.
D. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.
E. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

問題 #3

You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted.
What steps would you perform to create a new audit file?

A. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME
'audit_log.so'; Delete the corrupted file. Restart the MySQL server.
B. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.
C. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.
D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.

問題 #4

Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation.

A. RELOAD
B. INDEX
C. CREATE TEMPORARY TABLES
D. GRAND OPTION
E. REPLICATION CLIENT

問題 #5

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/bin is needed.
B. The configuration log-bin=/app/data is needed.
C. The configuration basedir=/app/mysql is needed.
D. The configuration innodb_log_group_home_dir=/datadir is needed.
E. The configuration datadir=/app/mysql/data is needed.
F. The configuration datadir=/app/data is needed.

解説：