Free Oracle 1Z1-922 Exam Dumps Questions & Answers

Which of the following replication topologies allows for multi-master replication where updates can be made on multiple servers?

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

Which MySQL feature allows an organization to track user activities for regulatory compliance, such as GDPR or HIPAA?

• A.  MySQL Query Optimizer
• B.  MySQL Enterprise Backup
• C.  MySQL InnoDB Cluster
• D.  MySQL Enterprise Audit

Which of the following types of joins will include all rows from the left table, even if there is no match in the right table?

• A.  LEFT JOIN
• B.  FULL OUTER JOIN
• C.  CROSS JOIN
• D.  INNER JOIN

Which MySQL privilege allows a user to create new databases?

• A.  DROP
• B.  CREATE
• C.  INSERT
• D.  UPDATE

Which two high availability features does MySQL InnoDB Cluster offer?

• A.  Asynchronous replication
• B.  Synchronous replication
• C.  On-demand backup creation
• D.  Automatic failover