Ceritified Information
A Cloud 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? Question: However, they are reporting that they are unable to create any more instances. What could be the problem? Options: The customer does … Read more
You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted. What steps would you perform to create a new audit file? Question: What steps would you perform to create a new audit file? Options: As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL … Read more
Which statement will display the status of the partitioning plug-in?INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= ‘partition’;Reference: https://dev.mysql.com/doc/refman/5.7/en/partitioning.html Question: Which statement will display the status of the partitioning plug-in? Options: SHOW STATUS PLUGINS WHERE Name= ‘PARTITIONING’; SHOW PLUGINS WHERE Name= ‘partition’; SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM USE SYS SCHEMA; SHOW PLUGINS STATUS; Correct Answer The Correct Answer for this … Read more
You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY. What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html Question: What command … Read more
Identify an example of creating an Enterprise Encryption function.Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/enterprise-encryption-installation.html Question: Identify an example of creating an Enterprise Encryption function. Options: [email protected] = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len); VALIDATE FUNCTION create_asymmetric_priv_key WITH ‘openssl_udf.so’; INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(‘RSA’, 1024)); CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME ‘openssl_udf.so’; Correct Answer The Correct Answer for this Question is CREATE FUNCTION … Read more
You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.Which two preventative actions should you take if your number of monitored MySQL instances has changed?(innodb_buffer_pool_size).Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html Question: Which two preventative actions should you take if your number of monitored MySQL instances has changed? … Read more
MySQL is installed on a Linux server and has the following configuration:[mysql]User=mysqlDatadir=/data/mysqlWhich two methods should you use to change the default options to use the authentication plug-in that implements SHA-256 hashing for user account passwords?Reference: https://dev.mysql.com/doc/refman/5.6/en/sha256-pluggable-authentication.html Question: Which two methods should you use to change the default options to use the authentication plug-in that implements … Read more
Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1.BEGIN;CREATE TABLE t1 (c1 INT);CREATE TABLE t2 (c1 INT); ROLLBACK;What is the result after issuing the ROLLBACK command? Question: What is the result after issuing the ROLLBACK command? Options: Both the tables, t1 and t2, are created. Only the t1 … Read more
Which query will find rows in a table that have no counterpart in another table?FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;Reference: https://stackoverflow.com/questions/18000564/mysql-query-for-finding-rows-that-are-in-onetable-but-not-another Question: Which query will find rows in a table that have … Read more
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?Reference: https://docs.oracle.com/cd/E17952_01/mysql-monitor-3.0-relnotes-en/news-3-0-0.html Question: How can you change the Advisor Setting? Options: Go to the configuration section (Users) and create a new user according to the existing … Read more