Get Certified for Mnc Companies
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,...
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...
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...
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...
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...
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...
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...
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:...
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=...
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...
