Oracle 1Z1-921 : MySQL 2021 Implementation Essentials

Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

• A. MySQL Dashboard
• B. Query Analyzer
• C. MySQL Advisors
• D. MySQL Query Analyzer

When should you perform a backup in a MySQL database?
Response:

• A. After every successful query execution.
• B. Only when the database size exceeds a certain limit.
• C. After critical data updates or before making significant changes to the database.
• D. Only during scheduled maintenance windows.

Which two methods help prevent MySQL security risks?

• A. Allow unauthorized clients to connect to the server.
• B. Use a firewall to control access to MySQL ports.
• C. Transmit plain (unencrypted) data over networks.
• D. Grant only permissions that a user requires.
• E. Ensure that MySQL accounts have short and easy passwords.
• F. Use the secure installation script "mysql_alays_secure_installation".

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

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

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.