あなたを合格させる1Z0-921お手軽に試験合格リアル1Z0-921練習問題集で更新されたのは2025年06月27日 [Q24-Q48]

あなたを合格させる1Z0-921お手軽に試験合格リアル1Z0-921練習問題集で更新されたのは2025年06月27日

2025年最新の実際に出ると確認されたで無料Oracle 1Z0-921試験問題

質問 # 24
What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?

• A. SMS-notification tab on the dashboard
• B. Browser pop-ups
• C. Email
• D. Direct support call from an Oracle representative
• E. Application-to-application messaging

正解：A、C

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

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

正解：D

質問 # 26
Which two deployment architectures could you use for scaling-out database reads?

• A. Implementing a three-node, single-primary InnoDB Cluster.
• B. Edit the configuration file and increase the value for parallel_read_workers and reboot the server
• C. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
• D. Altering the storage engine for all tables to memory to increase performance.
• E. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

正解：A、D

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

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

正解：C

質問 # 28
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. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
• B. 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.
• C. 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.
• D. 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.

正解：C

質問 # 29
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 account might have reached resource quota/limits.
• B. The customer reached the database instance limit of 32.
• C. The customer does not have proper user rights.
• D. 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.

正解：B

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

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

正解：B、C、E

質問 # 31
Which two statements are true about MySQL Enterprise Firewall?

• A. 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.
• B. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• C. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• E. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• F. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

正解：B、D

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

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

正解：D、E、F

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

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

正解：B、C、D

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

正解：A

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

正解：D、E

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

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

正解：B

質問 # 37
The user 'fwuser'@'localhost% was registered with the MySQL Enterprise Firewall and was granted privileges for the SAKILA database. You executed the commands:

You want to clear the account whitelist for the * fwuser" @* localhost* user. Which statement should you run to accomplish this?

• A.
• B.
• C.

正解：B

質問 # 38
You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

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

正解：D

質問 # 39
You need to change the password level for a test system.
Which two allow to change this level before you create new test user/passwords?

• A. Add validate_password=,new level, in the [security] section of the MySQL configuration file.
• B. SET GLOBAL validate_password_policy=,new level,;
• C. SET GLOBAL force_password_complex_policy=0;
• D. Add validate_password_policy=,new level, in the [mysqld] section of the MySQL configuration file.

正解：B、D

質問 # 40
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 Online Hot Backup to keep data consistent and always ready to be used.
• C. MySQL Servers with Group Replication to replicate data to all members of the cluster.
• D. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.
• E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

正解：A、C、E

質問 # 41
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.

正解：C

質問 # 42
Which two statements are true about the creation or use of a Virtual Cloud Network (VCN)?

• A. You can connect directly to the VCN without a define subnet.
• B. You must have an IPSec VPN to connect to an Oracle Linux instance.
• C. You must have an Internet gateway to connect to a public address on an Oracle Linux instance.
• D. Your instance does not have a public IP address, so you cannot connect with a public subnet.
• E. You can connect directly to an instance over the internet, without a public IP address.

正解：A、E

質問 # 43
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 (MEM) and configure the default login credentials.
• B. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
• C. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
• D. 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.

正解：D

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

正解：A、C

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

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

正解：C

質問 # 46
The user -os-user'@"localhost" was created to monitor connections and shut down the server, and was granted these privileges:
GRANT PROCESS, SHUTDOWN ON *.* TO "OS-user*@"localhost';
Which three are commands that the os-user can execute?

• A. GRANT PROXY
• B. SHOW PROCESSLIST;
• C. SHOW STATUS;
• D. KILL PROCESS;
• E. SHUTDOWN
• F. SHOW BINLOG EVENTS;

正解：C、D、E

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

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

正解：B、E

質問 # 48
......

1Z0-921リアル試験問題解答は無料：https://jp.fast2test.com/1Z0-921-premium-file.html