Online Access Free 1Z0-920 Practice Test

Which three are requirements for MySQL Group Replication (GR)?

• A.The use of global transaction identifiers is required.
• B.The binary log format must be set to mixed.
• C.Primary keys are required on every replicated table.
• D.The minimum number of required nodes for achieving a consensus is two.
• E.Data to be replicated must be stored in the InnoDB transactional storage engine.
• F.GR only works with MySQL versions 8.0.12 or higher.

You execute this statement:
SELECT NULL=NULL;
What is the result?

• A.TRUE
• B.1
• C.0
• D.FALSE
• E.NULL

You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

• A./usr/bin/logs
• B./usr/mysql
• C./etc/my.cnf
• D./var/lib/mysql/innodb
• E./var/lib/mysql
• F./usr/redo

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.System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.
• E.On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• F.MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

Which two statements about the download of MySQL Enterprise Backup are correct?

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