Oracle MySQL Implementation Associate - 1Z1-922 Exam Practice Test

A. Start and stop the MySQL server

B. View active queries and processes

C. Grant privileges to other users

D. Terminate user sessions

A. To enforce password policies for users

B. To optimize query execution

C. To integrate MySQL with external authentication systems

D. To create backups of MySQL databases

A. MySQL Enterprise Monitor

B. MySQL Query Optimizer

C. MySQL Enterprise Backup

D. MySQL InnoDB Cluster

A. SHOW GRANTS FOR 'user'@'host';

B. DELETE FROM mysql.user WHERE user='user';

C. ALTER USER 'user'@'host' ACCOUNT LOCK;

D. REVOKE ALL PRIVILEGES FROM 'user'@'host';

A. A learned pattern of allowed SQL queries

B. Query execution time

C. Database size

D. Predefined user roles

A. It provides automatic failover and high availability

B. It requires no configuration changes

C. It allows multi-source replication

D. It uses binary logs for faster backups

A. /var/mysql/settings.conf

B. /etc/my.cnf

C. /usr/mysql/config.cnf

D. /etc/mysql/server.cnf

A. To synchronize databases across different cloud platforms

B. To backup the database

C. To copy data from one MySQL server to another

D. To distribute database queries

A. Add a PRIMARY KEY constraint

B. Add an AUTO_INCREMENT attribute

C. Use a sequence

D. Use a UNIQUE constraint

A. query_cache_limit

B. query_cache_size

C. innodb_flush_method

D. query_cache_type