最新の[2025年04月26日]1Z0-921試験問題集で有効で更新された問題集 [Q35-Q60]

最新の[2025年04月26日]1Z0-921試験問題集で有効で更新された問題集

無料お試しまもなく終了！100%有効な1Z0-921試験問題集には78問があります

Oracle 1Z0-921試験は、MySQLデータベースの実装と管理における知識とスキルをテストする認定試験であり、MySQLデータベースと取り組むプロフェッショナルがこの領域での専門知識を証明するために設計されています。これは、MySQLを使用するデータベース管理者、開発者、コンサルタントの人気のある認定資格です。

Oracle 1Z0-921認定試験は、グローバルに認識されているベンダー中立認証です。これは、MySQLデータベースの実装のすべての側面をカバーする包括的な試験です。この試験に合格した候補者は、MySQLアーキテクチャ、インストール、構成、および最適化を深く理解します。また、MySQLデータベースに関連する問題をトラブルシューティングおよび解決することもできます。

 

質問 # 35
What is Kubernetes in the context of MySQL?
Response:

• A. A cloud service provided by Oracle for MySQL databases.
• B. A database management tool for MySQL.
• C. An open-source container orchestration platform.
• D. A database engine for MySQL.

正解：C

質問 # 36
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,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
• B. CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
• C. CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
• D. CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)
• E. CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE

正解：A

質問 # 37
What are Security Lists in Oracle Cloud Infrastructure?

• A. They are user-role designations that assign rights to certain internal users and external users.
• B. Security lists are data encryption levels that control who can see the data.
• C. They are essentially firewall rules that help control traffic between OCI instances.
• D. They allow administrators access to applications in the cloud and external servers.
• E. They contain rules established by HIPAA for securing end-user data.

正解：C

質問 # 38
Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A. use SSD,s for data and replication logs
• B. The number of machines per group must be 3, 5, 7 or 9.
• C. isolated machine resources
• D. Groups must be in even numbers; 2, 4, 6, 8.
• E. Networks must be in separate regions.
• F. Use Network-attached storage (NAS) for the data files.
• G. smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM

正解：B、D、F

質問 # 39
Which two statements about the download of MySQL Enterprise Backup are correct?

• A. MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
• B. MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.
• C. MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
• D. MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.
• E. MySQL Enterprise Backup comes with all MySQL editions including community edition.

正解：B、E

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

正解：A、C

質問 # 41
Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

• A. existing VCN
• B. Object Storage
• C. Custom Image
• D. bare metal Oracle Linux shape
• E. ssh key pair
• F. subnet configured on a Virtual Cloud Network (VCN)

正解：B、C、D

質問 # 42
Which two statements are true about MySQL Enterprise Authentication?

• A. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.
• B. MySQL Enterprise Authentication determines what operation the user can perform.
• C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).
• D. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..
• E. MySQL Enterprise Authentication supports Windows Active Directory.

正解：C、E

質問 # 43
You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH) For accessing a new MySQL Enterprise Edition on an Oracle Cloud Infrastructure (OCI) Instance you " Add SSH key " information during the OCI instance setup. You want to use Putty from your Windows Client to install MySQL.
What are the correct steps to accomplish this?

• A. Open Port 22 on your OCI Instance and convert the private key to ppk format. This new private key can be used for authentication.
• B. Use the provided private key for authentication.
• C. Convert the private key to ppk format first and use the new private key for authentication.
• D. Open Port 22 on your OCI Instance and configure Putty with the ssh private key.

正解：A

質問 # 44
The slave connects to the master and asks for updated records. What command was issued for this to happen?

• A. START SLAVE
• B. RUN SLAVE
• C. START RUN SLAVE
• D. SLAVE RUN
• E. SLAVE START

正解：E

質問 # 45
Which three are characteristics of the JSON data type?

• A. A set of SQL functions substantially support the SQL utilization of the data type.
• B. Comparisons of JSON values are not case-sensitive.
• C. It is based on the TEXT data type.
• D. It validates the JSON syntax on insert or merge.
• E. Key or array references enable quick read-access to look up document elements directly.
• F. It supports indexing directly against the JSON-defined column.

正解：D、E、F

質問 # 46
When should you perform a backup in a MySQL database?
Response:

• A. After critical data updates or before making significant changes to the database.
• B. After every successful query execution.
• C. Only during scheduled maintenance windows.
• D. Only when the database size exceeds a certain limit.

正解：A

質問 # 47
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.
Which two are possible reasons for this problem?

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

正解：B、D

質問 # 48
Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

• A. creating e-mail alerts and SNMP traps for MySQL warnings
• B. tracing import and export with mysqldump
• C. monitoring the availability of the MySQL Instance
• D. analyzing executed MySQL queries
• E. starting and stopping the MySQL instance
• F. deploying MySQL agent on supported target operating system

正解：A、B、F

質問 # 49
Which two statements are correct about MySQL Enterprise Edition?

• A. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.
• B. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.
• C. MySQL configuration can be changed in /etc/lib/myi.cnf.
• D. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.
• E. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

正解：C、E

質問 # 50
The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?

• A.
• B.
• C.
• D.

正解：B

質問 # 51
Which of the following statements is true regarding MySQL user account privileges?
Response:

• A. A user with the SUPER privilege can only read data from the database.
• B. The GRANT option allows a user to revoke privileges from other users.
• C. The USAGE privilege allows a user to connect to the MySQL server but grants no other privileges.
• D. The RELOAD privilege allows a user to delete data from a table.

正解：C

質問 # 52
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. Both Cloud storage and local storage
• B. Cloud storage only
• C. Flash-archive recovery area
• D. Cloud tape library

正解：A、B

質問 # 53
You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

• A. The table statistics will be stored.
• B. The table will be checked for errors and repaired.
• C. The table will be optimized and replicated.
• D. The table storage space will be reduced.

正解：C

質問 # 54
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. The opc user
• B. Public IP address
• C. User Password
• D. SSH private key
• E. The root user
• F. SSH public key

正解：A

質問 # 55
Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

• A. MySQL Dashboard
• B. Query Analyzer
• C. MySQL Query Analyzer
• D. MySQL Advisors

正解：C

質問 # 56
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=FORCE_PLUS_PERMANENT
• C. LOAD PLUGIN=AUDIT_LOG
• D. plugin-audit=ON, ALWAYS
• E. audit_log_permanent=ON

正解：B、E

質問 # 57
After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

• A. The root password is not given and is blank. You must manually set the root password.
• B. The root password displayed on the screen via a [warning] message.
• C. As root, execute the show password command by using the SHA-256 password encryption plug-in.
• D. The root_pw variable stored in the mysq1.install table.
• E. The root password inserted in the error log set by the --log-error=[file_name] variable

正解：C、D

質問 # 58
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. To safely purge binary log files, perform these steps:
• B. On the Master server, disable binlog by removing the --log-bin option.
• C. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
• D. Delete all binlog files manually on the file system to release storage spaces.
• E. Execute the purge binary logs statement without argument.

正解：A、C

質問 # 59
Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

• A. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.
• B. MySQL Servers with Group Replication to replicate data to all members of the cluster.
• C. MySQL Online Hot Backup to keep data consistent and always ready to be used.
• D. MySQL Router to ensure client requests are load balanced and routed to the correct servers.
• E. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

正解：A、B、D

質問 # 60
......

Oracle 1Z0-921試験は、MySQLデータベースの実装および管理に関連するさまざまなタスクを実行する候補者の能力を測定します。試験の目的には、MySQLアーキテクチャの理解、MySQLサーバーのコンポーネントの使用、MySQLサーバーオプションの構成、MySQLユーザーアカウントと権限の管理、MySQLストレージエンジンの理解、テーブルの作成および操作、MySQLデータベースのバックアップとリカバリの管理が含まれます。

 

1Z0-921試験問題集で100%高得点させる1Z0-921試験解答がこちら：https://jp.fast2test.com/1Z0-921-premium-file.html