Online Access Free 1Z0-922 Practice Test

How can you disable a user account in MySQL without deleting it?

• A.By removing all privileges from the user
• B.By issuing ALTER USER 'user'@'host' ACCOUNT LOCK; BCy. issuing REVOKE ALL PRIVILEGES FROM 'user';

How does the HeatWave Cluster scale to handle increasing workloads?

• A.By enabling asynchronous replication
• B.By automatically replicating data across regions
• C.By creating additional binary logs
• D.By adding more HeatWave nodes to process queries in parallel

What is the purpose of the RELOAD privilege in MySQL?

• A.To restart the MySQL server
• B.To grant privileges to other users
• C.To reload privilege tables without restarting the server
• D.To load new data into a table

Which parameter in MySQL configures the maximum number of connections that can be handled simultaneously by the server?

• A.innodb_max_connections
• B.thread_cache_size
• C.max_threads
• D.max_connections

Which of the following types of joins will include all rows from the left table, even if there is no match in the right table?

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