We're so confident of our products that we provide no hassle product exchange.
Oracle MySQL 2021 Implementation Essentials Sample Questions:
1. You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?
A) Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
B) Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.
C) Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
D) Use mysqldump with the - -changesonly option.
E) Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
2. 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) LOAD PLUGIN=AUDIT_LOG
B) audit_log_permanent=ON
C) audit-log=FORCE_PLUS_PERMANENT
D) plugin-load=audit_log.so
E) plugin-audit=ON, ALWAYS
3. Which statement adds a column with the largest integer data type?
A) ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);
B) ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);
C) ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;
D) ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
4. 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) User Password
B) The root user
C) The opc user
D) Public IP address
E) SSH private key
F) SSH public key
5. You have a backup image file that is backed up using MySQL Enterprise Backup with the -compress option:
/home/mysq1/backup/full/mybackup/myimage. Img
You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?
A) 
B) 
C) 
D) 
E) 
Solutions:
| Question # 1 Answer: B,D | Question # 2 Answer: B,C | Question # 3 Answer: D | Question # 4 Answer: C | Question # 5 Answer: E |
By Marlon
