考試大綱會不定期調整，過時的題庫只會浪費你的時間。Fast2test 的 1Z0-920 練習題持續審查與更新，2026 年購買還享有 365 天免費更新，讓你練的每一題都緊貼 Oracle MySQL 2019 Implementation Essentials 的最新範圍。

Oracle 1Z0-920 考試概覽:

Oracle 1Z0-920 考試大綱主題:

Oracle MySQL 2019 Implementation Essentials 考生最常問的問題

最新的 MySQL Cloud Service 1Z0-920 免費考試真題：

問題 #1

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

問題 #2

What are Security Lists in Oracle Cloud Infrastructure?

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

問題 #3

Which statement will display the status of the partitioning plug-in?

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

問題 #4

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. KILL PROCESS;
B. GRANT PROXY
C. SHUTDOWN
D. SHOW BINLOG EVENTS;
E. SHOW STATUS;
F. SHOW PROCESSLIST;

問題 #5

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';

問題與答案：