Which MySQL command is used to display a list of all active users connected to the database?

• A.SHOW PROCESSLIST;
• B.SHOW USERS;
• C.SHOW CONNECTIONS;
• D.SHOW PRIVILEGES;

Comment: *

Name: *

Email: *

Verification: *

What is the role of the GTID (Global Transaction Identifier) in a MySQL InnoDB Cluster?

• A.It improves query performance
• B.It tracks transactions across all nodes to ensure consistency
• C.It stores query execution plans
• D.It ensures database backups are consistent

Comment: *

Name: *

Email: *

Verification: *

Which statement would you use to rename a MySQL user without affecting their privileges?

• A.ALTER USER 'old_user'@'host' TO 'new_user'@'host';
• B.RENAME USER 'old_user'@'host' TO 'new_user'@'host';
• C.UPDATE mysql.user SET User = 'new_user' WHERE User = 'old_user';
• D.REVOKE ALL PRIVILEGES ON *.* FROM 'old_user';

Comment: *

Name: *

Email: *

Verification: *

Which of the following components is responsible for handling user authentication in MySQL?

• A.Query Optimizer
• B.Connection Manager
• C.MySQL Server
• D.Storage Engine

Comment: *

Name: *

Email: *

Verification: *

Which of the following features is exclusive to MySQL Enterprise Edition for backup management?

• A.MySQL Dump
• B.MySQL Enterprise Backup
• C.MySQL Shell
• D.MySQL Workbench Backup Utility

Comment: *

Name: *

Email: *

Verification: *