What does MySQL Enterprise Backup provide that is not available with the Community Edition?

• A.Backup scheduling
• B.Point-in-time recovery
• C.Real-time query analysis
• D.Integration with LDAP

Comment: *

Name: *

Email: *

Verification: *

Which command is used in MySQL Shell to create a new InnoDB Cluster?

• A.cluster.create()
• B.cluster.init()
• C.create.cluster()
• D.setupInnoDB()

Comment: *

Name: *

Email: *

Verification: *

How can you modify the structure of an existing table in MySQL, such as adding a new column?

• A.MODIFY TABLE
• B.CHANGE TABLE
• C.ALTER TABLE
• D.UPDATE TABLE

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 SQL commands is blocked by default in MySQL Enterprise Firewall if it detects it as suspicious or unauthorized?

• A.SELECT
• B.INSERT
• C.DROP DATABASE
• D.DESCRIBE

Comment: *

Name: *

Email: *

Verification: *