Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. Which statement would you use to remove the population column from the city table?

A) ALTER TABLE city DELETE population;
B) ALTER TABLE city LESS population;
C) DROP population FROM city;
D) DELETE population FROM city;
E) ALTER TABLE city DROP population;

2. 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 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.
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 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.
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 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.
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 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.

3. You get a maintenance-notification about your MySQL Enterprise Edition in Oracle Cloud Infrastructure (OCI) Compute instance. What is re the implication?

A) You need to agree to the maintenance windows. If not, you are not affected by the outage.
B) You can expect an outage of your MySQL OCI instance during the planned time..
C) There are no maintenance operations planned. You need to do them manually.
D) Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

4. Which query will find rows in a table that have no counterpart in another table?

A) SELECT t1.name, t2.name2FROM employee AS t1 INNER JOIN info AS t2 ON t1.name= t2.name2;
B) SELECT t1.name, t2.name2FROM employee t1 INNER JOIN info t2 WHERE t1.name=t2.name;
C) SELECT left_tbl.*FROM left_tbl LEFT JOIN right_tbl ON left_tbl.id=right_tbl.idWHERE right_tbl.id IS NULL;
D) SELECT *FROM table1 INNER JOIN table2 ON table1.id=table2.id WHERE table1.id=! table2.id;

5. Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

A) Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
B) Allocating more CPU to the database instance to improve throughput performance.
C) Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.
D) Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
E) Increasing the storage capacity so that the database can store more data to scale.

Solutions: