How does MySQL handle crash recovery in the InnoDB storage engine?

• A.By using the binary log to replay all queries
• B.By using undo logs and redo logs for transaction recovery
• C.By using table-level backups
• D.By recreating indexes after each crash

Comment: *

Name: *

Email: *

Verification: *

Which two features are part of MySQL Enterprise Security Tools?

• A.MySQL Enterprise Authentication
• B.MySQL Enterprise Audit
• C.MySQL Performance Schema
• D.MySQL Query Cache

Comment: *

Name: *

Email: *

Verification: *

Which MySQL Enterprise Edition feature allows you to track database activity in order to meet compliance requirements?

• A.MySQL Enterprise Firewall
• B.MySQL Enterprise Monitor
• C.MySQL Enterprise Audit
• D.MySQL Enterprise Backup

Comment: *

Name: *

Email: *

Verification: *

Which statement is used to create a new table in MySQL?

• A.CREATE NEW TABLE
• B.CREATE DB_TABLE
• C.CREATE TABLE
• D.NEW TABLE

Comment: *

Name: *

Email: *

Verification: *

What is the benefit of using MySQL Enterprise Authentication over standard MySQL authentication?

• A.Faster query execution
• B.Integration with external authentication systems like LDAP
• C.Enhanced database replication
• D.Higher storage efficiency

Comment: *

Name: *

Email: *

Verification: *