Online Access Free 1Z1-922 Practice Test

Which component of MySQL is responsible for executing SQL statements?

• A.Query Optimizer
• B.Storage Engine
• C.Information Schema
• D.MySQL Server

Which MySQL Enterprise Security Tool can log failed login attempts to detect potential attacks?

• A.MySQL Enterprise Monitor
• B.MySQL Enterprise Authentication
• C.MySQL Enterprise Firewall
• D.MySQL Enterprise Audit

How can you track the slowest queries in MySQL?

• A.By enabling the Query Cache
• B.By using the Slow Query Log
• C.By monitoring the Error Log
• D.By using MySQL Enterprise Backup

Which statement best describes asynchronous replication in MySQL?

• A.The primary server waits for all replicas to apply changes before committing
• B.The replica is always up to date with the primary
• C.Changes are applied to the replica in real time
• D.The primary server does not wait for the replica to confirm changes before committing

Which type of join returns only the rows where there is a match in both tables?

• A.JOIN INNER JOIN
• B.LEFT JOIN RIGHT
• C.FULL OUTER JOIN D.