Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?
A. creating e-mail alerts and SNMP traps for MySQL warnings
B. starting and stopping the MySQL instance
C. analyzing executed MySQL queries
D. deploying MySQL agent on supported target operating system
E. monitoring the availability of the MySQL Instance
F. tracing import and export with mysqldump
MySQL Enterprise Masking and De-identification can hide or obfuscate sensitive data, by controlling how the data appears. Which three are MySQL Enterprise Masking and De-identification functions?
A. misspelling
B. strict or relaxed masking
C. random data substitution
D. whitelisting and substitution
E. dictionary substitution
You just installed MySQL by Using a Package Manager on Linux. Where are the default InnoDB redo log files stored?
A. /usr/mysql
B. /var/lib/mysql
C. /var/lib/mysql/innodb
D. /usr/bin/logs
E. /usr/redo
F. /etc/my.cnf
You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1
ENCRYPTION = 'Y1;
You receive the following error:
ERROR 1031 (HY000): Table storage engine for `test_encryption2' doesn't have this option Which
statement correctly explains the reason for this error?
A. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
B. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
C. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
D. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.
What is true about MySQL Enterprise Transparent Data Encryption (TDE)?
A. Data is encrypted automatically, in real time, after it is written to storage.
B. Enables data-at-rest encryption by encrypting the physical files of the database.
C. Encryption key is stored in a centralized key memory location
D. Tablespace keys are managed manually behind the scenes.
Which is true about inserting an additional line in a single document stored in MySQL document store?
A. You specify the new element's position in the JSON_ARRAY_INSERT statement.
B. Any new lines can only be inserted at the end of the document.
C. You cannot insert a single line, you have to replace the entire document with a new document.
D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
You have created your Compute instance using an Oracle-provided Oracle Linux image. You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?
A. Public IP address
B. User Password
C. SSH private key
D. The opc user
E. SSH public key
F. The root user
Which Oracle product is certified to work with MySQL Enterprise Edition?
A. Oracle Enterprise Backup
B. Oracle Data Pump
C. Oracle Enterprise Manager
D. Oracle Application Express
An existing MySQL Database environment has been doing backup and restore in a logical way by using the mysq1dump and mysq1 client utilities. When the backup is started using mysqldump with single-transaction mode, the existing application has long wait time. When the restore is required, it takes more than three hours to restore. What two are benefits of using mysqlbackup from MySQL Enterprise Backup in this situation?
A. MySQL Enterprise Backup does not back up system data so that it is much faster.
B. MySQL Enterprise Backup provides tape backup integration by default. It has the virtual tape option, which allows backup to tape device directly without extra third-party software integration.
C. mysqlbackup can back up tables with the InnoDB engine without blocking. The backup is hot with InnoDB. Together with Incremental Backup, mysqlbackup from MySQL Enterprise Backup shortens the backup windows.
D. mysqlbackup utilities dump the full database into a SQL file, which is imported into the mysql client in single-thread mode. mysqlbackup restores data from physical backups. Physical backup methods are faster than logical methods because they involve only file coping without conversion.
E. mysqlbackup from MySQL Enterprise Backup allows logical backup with concurrency built in to get faster backup speed and restoration speed.
Which three statements are true about MySQL Enterprise Backup?
A. It performs hot or warm backups.
B. It provides the ability to create incremental backups.
C. It cannot back up encrypted tablespaces.
D. It enables you to take non-locking backups.
E. It performs logical backups.