Online Access Free 1Z0-922 Exam Questions

Which datatype is the best choice for storing binary large objects (BLOBs), such as images or files?

• A.ENUM
• B.INT
• C.BLOB
• D.TEXT

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

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

Which component of MySQL is responsible for executing SQL statements?

• A.Storage Engine
• B.Query Optimizer
• C.Information Schema
• D.MySQL Server

In a MySQL InnoDB Cluster, what happens when a node becomes unreachable?

• A.All write operations are blocked
• B.The remaining nodes continue to operate, and the cluster self-heals when the node recovers
• C.The node is automatically demoted to a replica
• D.The cluster stops all transactions until the node recovers

What is the purpose of the InnoDB undo log?

• A.To track uncommitted changes and allow rollback if needed
• B.To store data modifications made by SELECT statements
• C.To store query results for future reference
• D.To ensure data replication between master and slave servers