Oracle 1Z1-921試験問題（更新されたのは2025年）100%リアル問題解答
合格させるOracle 1Z1-921試験最速合格
Oracle 1Z0-921: MySQL 2021 Implementation Essentials 認定試験は、MySQL データベースの実装と保守に関する専門知識を習得したいプロフェッショナル向けに設計されています。この試験は、60 問の問題から構成され、受験者は 105 分間で試験を完了する必要があります。この試験は、MySQL のアーキテクチャ、セキュリティ、バックアップおよびリカバリ、およびパフォーマンスチューニングなどの分野における受験者の知識とスキルを評価するために設計されています。
Oracle 1Z0-921：MySQL 2021実装Essentials試験は、MySQLデータベースを扱う専門家にとって貴重な認証です。この試験に合格することにより、候補者はMySQLの実装と管理に関する専門知識を実証でき、それがより良い雇用機会とより高い給与につながる可能性があります。適切な準備とトレーニングにより、候補者は試験に合格し、この貴重な認証を獲得できます。
質問 # 13
Which of the following statements is true regarding MySQL user account privileges?
Response:
- A. The RELOAD privilege allows a user to delete data from a table.
- B. A user with the SUPER privilege can only read data from the database.
- C. The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.
- D. The GRANT option allows a user to revoke privileges from other users.
正解：C
質問 # 14
Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:
- A. MySQL Query Analyzer
- B. MySQL Dashboard
- C. MySQL Advisors
- D. Query Analyzer
正解：A
質問 # 15
The slave connects to the master and asks for updated records. What command was issued for this to happen?
- A. RUN SLAVE
- B. START SLAVE
- C. SLAVE START
- D. SLAVE RUN
- E. START RUN SLAVE
正解：C
質問 # 16
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore.
What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?
- A. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.
- B. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
- C. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
- D. MySQL Enterprise Backup does not back up system data so that it is much faster.
- E. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
正解：B、C
質問 # 17
You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?
- A. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
- B. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
- C. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
- D. CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
- E. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
正解：D
質問 # 18
An Oracle Cloud Infrastructure 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 does not have proper user rights.
- 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 account might have reached resource quota/limits.
正解：C
質問 # 19
Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:
What is the result after issuing the rollback command?
- A. Only the t1 table is created.
- B. Only the t2 table is created.
- C. Both the tables, t1 and t2, are created.
- D. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
正解：C
質問 # 20
You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?
- A. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
- B. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
- C. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
- D. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
正解：B
質問 # 21
When should you perform a backup in a MySQL database?
Response:
- A. Only when the database size exceeds a certain limit.
- B. After every successful query execution.
- C. After critical data updates or before making significant changes to the database.
- D. Only during scheduled maintenance windows.
正解：C
質問 # 22
What are the two main components required to set up persistent storage for MySQL on Kubernetes?
Response:
- A. Pod and ReplicaSet
- B. PVC (Persistent Volume Claim) and PV (Persistent Volume)
- C. Secret and Deployment
- D. PVC (Persistent Volume Claim) and ConfigMap
正解：B
質問 # 23
Which two statements are true about MySQL Enterprise Firewall?
- A. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
- B. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
- C. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
- D. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
- E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
- F. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
正解：B、E
質問 # 24
Which is true about inserting an additional line in a single document stored in MySQL document store?
- A. You specify the new element,s position in the JSON_ARRAY_INSERT statement.
- B. You cannot insert a single line, you have to replace the entire document with a new document.
- C. Any new lines can only be inserted at the end of the document.
- D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
正解：A
質問 # 25
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. plugin-load=audit_log.so
- B. audit_log_permanent=ON
- C. plugin-audit=ON, ALWAYS
- D. audit-log=FORCE_PLUS_PERMANENT
- E. LOAD PLUGIN=AUDIT_LOG
正解：B、D
質問 # 26
You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?
- A. User Password
- B. SSH private key
- C. SSH public key
- D. The opc user
- E. Public IP address
- F. The root user
正解：D
質問 # 27
When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?
- A. Cloud storage only
- B. Cloud tape library
- C. Flash-archive recovery area
- D. Both Cloud storage and local storage
正解：A、D
質問 # 28
Which statement would you use to remove the population column from the city table?
- A. DROP population FROM city;
- B. ALTER TABLE city DROP population;
- C. ALTER TABLE city LESS population;
- D. DELETE population FROM city;
- E. ALTER TABLE city DELETE population;
正解：B
質問 # 29
Which Oracle product is certified to work with MySQL Enterprise Edition?
- A. Oracle Enterprise Manager
- B. Oracle Data Pump
- C. Oracle Enterprise Backup
- D. Oracle Application Express
正解：A
質問 # 30
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?
- A. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.
- B. You can expect an outage of your MySQL OCI instance during the planned time..
- C. You need to agree to the maintenance windows. If not, you are not affected by the outage.
- D. There are no maintenance operations planned. You need to do them manually.
正解：B
質問 # 31
Which three are levels in which MySQL Enterprise Monitor provides access control?
- A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services
- B. Specific data access: the rights to view specific types of potentially sensitive data
- C. Asset visibility: the rights to access data collected from hosts or MySQL instances
- D. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent
- E. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration
正解：B、C、E
質問 # 32
What three are ways to export and import data in MySQL Workbench?
- A. Result Data Export and Import
- B. Data Modeling Import Export Wizard
- C. Backup Data Export and Import Wizard
- D. Table Data Export and Import Wizard
- E. Binary Data Export and Import Wizard
- F. SQL Data Export and Import Wizard
正解：A、D、F
質問 # 33
The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?
- A. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
- B. On the Master server, disable binlog by removing the --log-bin option.
- C. Delete all binlog files manually on the file system to release storage spaces.
- D. To safely purge binary log files, perform these steps:
- E. Execute the purge binary logs statement without argument.
正解：A、D
質問 # 34
Which three statements describe MySQL Enterprise Backup?
- A. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
- B. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
- C. MySQL Enterprise Backup provides the point-in-time recovery functionality.
- D. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
- E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
正解：B、C、E
質問 # 35
......
Oracle 1Z0-921：MySQL 2021実装Essentials試験は、MySQLデータベースの実装と管理における候補者の知識とスキルを検証する業界に認識されている認定です。この試験は、MySQLデータベースを使用し、この分野での専門知識を実証したい専門家向けに設計されています。この試験に合格することにより、候補者はMySQLデータベースのインストール、構成、および管理に習熟度を証明できます。
リアルOracle 1Z1-921試験問題 [更新されたのは2025年]：https://jp.fast2test.com/1Z1-921-premium-file.html