Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A) A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
B) A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database
C) A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database
D) A browser-based wizard to remotely deploy the MySQL Monitor Agent
E) A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

2. Which three statements are true about MySQL Enterprise Backup?

A) It enables you to take non-locking backups.
B) It provides the ability to create incremental backups.
C) It performs hot or warm backups.
D) It performs logical backups.
E) It cannot back up encrypted tablespaces.

3. You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

A) /usr/bin/logs
B) /usr/redo
C) /var/lib/mysql/innodb
D) /etc/my.cnf
E) /var/lib/mysql
F) /usr/mysql

4. You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

A) 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.
B) 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
C) 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
D) 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.

5. You want to create the user named jenny for any host server with the password secretpassi23! and the password is expired? Which command should you use?

A) CREATE USER ,jenny,@,%, IDENTIFIED WITH sha256_password BY 'SecretPass123!,;
B) CREATE USER ,jenny,0,%t IDENTIFIED BY ,SecretPass123!, PASSWORD EXPIRE;
C) CREATE USER ,jenny,@'%, WITH HASHED(password,,SecretPass123!,), PASSWORD EXPIRE
D) CREATE USER ,jenny,@,localhost, IDENTIFIED BY (,SecretPass123!,,,256,, Expired)
E) CREATE USER ,jenny *@,localhost, IDENTIFIED WITH HASH PASSWORD(,SecretPass123!,)

Solutions: