本番の試験会場で時間切れになってしまった、という声は珍しくありません。CertShikenの1Z0-920模擬試験は実際の試験環境を再現しており、Oracle MySQL 2019 Implementation Essentialsの制限時間や問題形式に慣れた状態で本番に臨めます。

Oracle 1Z0-920 試験概要:

認定ベンダー:	Oracle
試験名:	MySQL 2019 実装の基礎
試験番号:	1Z0-920
出題数:	70
対応言語:	English
関連資格:	Oracle MySQL Implementation Associate
サンプル問題:
受験方法:	認定試験会場でのコンピュータベース試験（CBT）またはオンライン監督試験
前提条件:	特に指定なし
公式シラバスのURL:	https://education.oracle.com/mysql-2019-implementation-essentials/pexam_1Z0-920

Oracle 1Z0-920 試験シラバストピック:

Oracle MySQL 2019 Implementation Essentialsに関するよくあるご質問

Oracle MySQL 2019 Implementation Essentials 認定 1Z0-920 試験問題：

問題 #1

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --uncompress
B. --decompress
C. --uncompress-and-apply-log
D. --copy-back-and-apply-log
E. --apply-log-and-copy-back

問題 #2

MySQL is installed on a Linux server with the configuration:

Which two methods can 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 on the command line when you invoke the server.
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. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

問題 #3

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.

問題 #4

Which statement would you use to remove the population column from the city table?

A. ALTER TABLE city DELETE population;
B. DELETE population FROM city;
C. ALTER TABLE city LESS population;
D. ALTER TABLE city DROP population;
E. DROP population FROM city;

問題 #5

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

A. audit_log_permanent=ON
B. plugin-load=audit_log.so
C. audit-log=FORCE_PLUS_PERMANENT
D. plugin-audit=ON, ALWAYS
E. LOAD PLUGIN=AUDIT_LOG

解説：