Oracle MySQL 2019 Implementation Essentials - 1Z0-920 Exam Practice Test

A. SET @function = CREATE_ASYMMETRIC_PRIV_KEY(@algo, @key_len);

B. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME 'openss1_udf.so';

C. VALIDATE FUNCTION create_asymmetric_priv_key WITH 'openssl_udf.so';

D. INSERT INTO t1 (key_co1) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY('RSA', 1024));

A. The binary log format must be set to mixed.

B. Primary keys are required on every replicated table.

C. The minimum number of required nodes for achieving a consensus is two.

D. The use of global transaction identifiers is required.

E. GR only works with MySQL versions 8.0.12 or higher.

F. Data to be replicated must be stored in the InnoDB transactional storage engine.

A. Cloud tape library

B. Flash-archive recovery area

C. Cloud storage only

D. Both Cloud storage and local storage

A. tracing import and export with mysqldump

B. deploying MySQL agent on supported target operating system

C. starting and stopping the MySQL instance

D. creating e-mail alerts and SNMP traps for MySQL warnings

E. monitoring the availability of the MySQL Instance

F. analyzing executed MySQL queries

A. MySQL Enterprise Product Suite can be installed on an Oracle Cloud Infrastructure Virtual Cloud Network.

B. MySQL configuration can be changed in /etc/lib/myi.cnf.

C. MySQL Enterprise Edition can be installed on an Oracle Cloud Infrastructure Compute Instance.

D. Oracle MySQL Enterprise tools & plugins are available as optional services (installation Feature Pack I/II).

E. Oracle offers 24x7, global support for MySQL Enterprise Edition products installed on Oracle Cloud Infrastructure Compute Instances.

A. A browser-based wizard to remotely deploy the MySQL Monitor Agent

B. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

C. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

D. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

E. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

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;