Which datatype in MySQL would you use to store a single character?

• A.TEXT
• B.CHAR(1)
• C.VARCHAR(1)
• D.ENUM

Comment: *

Name: *

Email: *

Verification: *

Which MySQL command is used to perform a logical backup using the mysqldump utility?

• A.mysqldump --all-databases > backup.sql
• B.mysqldump --backup-databases
• C.mysqlbackup --dump
• D.mysqlbackup --backup-log

Comment: *

Name: *

Email: *

Verification: *

Which of the following actions can MySQL Enterprise Audit log for compliance purposes?

• A.User login attempts
• B.Changes to database schemas
• C.Execution of specific SQL queries
• D.All of the above

Comment: *

Name: *

Email: *

Verification: *

Which statement best describes asynchronous replication in MySQL?

• A.The replica is always up to date with the primary
• B.The primary server waits for all replicas to apply changes before committing
• C.The primary server does not wait for the replica to confirm changes before committing
• D.Changes are applied to the replica in real time

Comment: *

Name: *

Email: *

Verification: *

Which MySQL feature allows for tracking failed login attempts and unauthorized access?

• A.MySQL Enterprise Monitor
• B.MySQL Enterprise Authentication
• C.MySQL Enterprise Audit
• D.MySQL InnoDB Cluster

Comment: *

Name: *

Email: *

Verification: *