Free Oracle 1Z1-922 Exam Dumps Questions & Answers

Which two high availability features does MySQL InnoDB Cluster offer?

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

Which MySQL Enterprise Edition feature helps to enforce user privileges?

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

Which of the following MySQL datatypes can store IP addresses in IPv4 format?

• A.BLOB
• B.VARCHAR(15)
• C.INT
• D.CHAR(15)

Which MySQL command is used to back up binary logs?

• A.mysqlbackup --binlog-backup
• B.mysqldump --log-backup
• C.mysqlbinlog
• D.mysqlbinlog --backup

What is the main difference between the TEXT and BLOB datatypes?

• A.TEXT stores numeric data, while BLOB stores string data
• B.BLOB can only store images
• C.TEXT stores string data, while BLOB stores binary data
• D.TEXT is faster to access than BLOB