Online Access Free 1Z1-922 Practice Test

Which privilege must be granted to a user to allow them to kill queries initiated by other users?

• A.PROCESS
• B.SUPER
• C.SHUTDOWN
• D.KILL

Which MySQL Enterprise Edition feature helps to enforce user privileges?

• A.Enterprise Backup MySQL Query
• B.MySQL Role-Based Access Control
• C.Cache
• D.MySQL Enterprise Monitor MySQL

Which command is used to shut down the MySQL server on a Linux system?

• A.service mysql-server shutdown
• B.mysqladmin --stop
• C.mysql shutdown
• D.systemctl stop mysqld

How do you ensure a MySQL table column automatically assigns a unique sequential value to each new row?

• A.Add an AUTO_INCREMENT attribute
• B.Use a UNIQUE constraint
• C.Use a sequence
• D.Add a PRIMARY KEY constraint

What is the function of the --apply-log option in the mysqlbackup command?

• A.To start a full backup
• B.To prepare a backup for restoration by applying changes from log files
• C.To delete old backup files
• D.To apply binary log changes after a backup