Free Oracle 1Z0-922 Exam Dumps Questions & Answers

Which two types of locks does the InnoDB storage engine use?

• A.Clustered index locking
• B.Row-level locking
• C.Table-level locking
• D.Page-level locking

What is the purpose of vectorized query processing in the HeatWave Cluster?

• A.To optimize OLTP queries
• B.To handle failover for analytic queries
• C.To compress data during storage
• D.To process multiple rows of data simultaneously for faster execution

Which replication topology allows each server to act as both a primary and a replica, enabling updates on any server?

• A.Circular replication
• B.Synchronous replication
• C.Primary-replica replication
• D.Multi-primary replication

Which of the following is a core requirement for setting up a MySQL InnoDB Cluster?

• A.Query caching must be turned off
• B.Binary log and GTID must be enabled
• C.Only one node can act as a primary
• D.Full-text indexing must be active

Which MySQL Enterprise Edition feature helps to enforce user privileges?

• A.Cache
• B.MySQL Role-Based Access Control
• C.MySQL Enterprise Monitor MySQL
• D.Enterprise Backup MySQL Query