[2025年更新]無料1Z1-921試験問題集は試験を合格するには超簡単 [Q19-Q35]

[2025年更新]無料1Z1-921試験問題集はパス試験は超簡単

1Z1-921試験問題集で1Z1-921練習テスト問題

Oracle 1Z0-921：MySQL 2021実装エッセンシャルズは、MySQLデータベースの実装と管理のスキルと知識を検証したいプロフェッショナル向けの認定試験です。この試験は、MySQLを使用するデータベース管理者、開発者、およびコンサルタントにとって、この人気のあるオープンソースの関係データベース管理システムでの熟練を示すための優れた機会です。

質問 # 19
Which is a correct example of creating an Enterprise Encryption function?

A. INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(,RSA,, 1024));
B. SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);
C. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ,openss1_udf.so,;
D. VALIDATE FUNCTION create_asymmetric_priv_key WITH ,openssl_udf.so';

正解：C

質問 # 20
What three are ways to export and import data in MySQL Workbench?

A. Backup Data Export and Import Wizard
B. Binary Data Export and Import Wizard
C. SQL Data Export and Import Wizard
D. Data Modeling Import Export Wizard
E. Table Data Export and Import Wizard
F. Result Data Export and Import

正解：C、E、F

質問 # 21
Which three options are valid reasons for using a primary key in a table?

A. increasing performance when using select statements
B. maintaining a history of row insertions or updates
C. preventing duplicate keys
D. automatic storage of data in a sorted order
E. exporting data faster with mysqldump
F. to make it easier to change the PRIMARY KEY value

正解：A、C、E

質問 # 22
Which three statements describe MySQL Enterprise Backup?

A. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
B. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
C. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
D. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
E. MySQL Enterprise Backup provides the point-in-time recovery functionality.

正解：A、B、E

質問 # 23
Which two are advantages of using Document Store in MySQL?

A. MySQL can store XML as a schema-less database
B. MySQL provides a native data type to store JSON data as a document
C. MySQL provides a NoSQL API to access the document store
D. MySQL provides a native data type to index PDF documents
E. MySQL is a document database allowing PDF and Word documents

正解：A、C

質問 # 24
Which activity will take place if a table is created with both the compression and encryption options?

A. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
B. The compression is performed before tablespace data is encrypted.
C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
D. The tablespace data is encrypted first and then compression is performed.

正解：B

質問 # 25
You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

A. There are no maintenance operations planned. You need to do them manually.
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. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

正解：B

質問 # 26
You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?

A. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
B. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
C. Go to the configuration section (MEM) and configure the default login credentials.
D. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

正解：A

質問 # 27
You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
B. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
D. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
E. Use mysqldump with the - -changesonly option.

正解：D、E

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

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

正解：A、C、D

質問 # 29
How would you restrict a user Joe from accessing all MySQL database objects?

A. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';
B. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.
C. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)
D. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;
E. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES

正解：B

質問 # 30
Which statement will display the status of the partitioning plug-in?

A. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';
B. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';
C. SHOW PLUGINS WHERE Name= 'partition';
D. USE SYS SCHEMA; SHOW PLUGINS STATUS;

正解：A

質問 # 31
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. --copy-back-and-apply-log
B. --decompress
C. --apply-log-and-copy-back
D. --uncompress
E. --uncompress-and-apply-log

正解：A、D

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

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

正解：C、D、E

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

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

正解：C、D

質問 # 34
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?