Which syntax accomplishes this?

You are required to set up a backup user (mysqlbackup@localhost) on the MySQL Database. The user should have the backup and restore privileges andadditional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables. Which syntax accomplishes this? A. CREATE USER `mysqlbackup’@localhost’IDENTIFIED BY `new-password’; B. CREATE USER `mysqlbackup’@localhost’ IDENTIFIED BY `new-password’; […]

Read More

What are two key differences between the use of ndbd and ndbmtd?

What are two key differences between the use of ndbd and ndbmtd? A. ndbd can be configured as ndbmtd by applying the option – – mtd. B. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id C. ndbd […]

Read More

Which two options should you include in the MySQL configuration file?

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time. Which two options should you include in the MySQL configuration file? A. audit_log_permanent=ON B. audit-log=FORCE_PLUS_PERMANENT C. plugin-load=audit_log.so D. plugin-audit=ON, ALWAYS E. LOAD PLUGIN=AUDIT_LOG Explanation:Reference: https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html Show Answer

Read More

Which three features are available?

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available? A. Deploying MySQL Agent on supported target operating system B. Tracing import and export with mysqldump C. Monitoring the availability of the MySQL instance D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings E. […]

Read More

How would you correct the problem?

After the installation of the MySQL Server, you cannot find MySQL Utilities.How would you correct the problem? A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install. B. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution. C. MySQL Utilities is a […]

Read More