Oracle MySQL 2019 Implementation Essentials - 1Z1-920 Free Exam Questions

A. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

B. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

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. 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.

F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;

B. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);

C. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;

D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);

A. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= 'partition';

B. USE SYS SCHEMA; SHOW PLUGINS STATUS;

C. SHOW PLUGINS WHERE Name= 'partition';

D. SHOW STATUS PLUGINS WHERE Name= 'PARTITIONING';

A. /usr/bin/logs

B. /usr/redo

C. /var/lib/mysql/innodb

D. /etc/my.cnf

E. /var/lib/mysql

F. /usr/mysql

A. User Password

B. Public IP address

C. The root user

D. SSH public key

E. The opc user

F. SSH private key

A. You forgot to create the correct SSL/TLC certificate during the setup process.

B. The opc user can be used to access MySQL only with the created SSH-Key.

C. Only root is allowed to access from non-localhost.

D. You forgot to enable port 3306.

E. The OCI instance is still in the "creation" process.

A. MySQL Enterprise No-Login Authentication

B. MySQL Enterprise Data Masking and De-identification

C. MySQL Enterprise Transparent Data Encryption (TDE)

D. MySQL Enterprise Audit

E. MySQL Enterprise Scalability