Online Access Free 1Z0-922 Exam Questions

What is the function of the --apply-log option in the mysqlbackup command?

• A.To prepare a backup for restoration by applying changes from log files
• B.To delete old backup files
• C.To start a full backup
• D.To apply binary log changes after a backup

How do you ensure a MySQL table column automatically assigns a unique sequential value to each new row?

• A.Use a sequence
• B.Add a PRIMARY KEY constraint
• C.Use a UNIQUE constraint
• D.Add an AUTO_INCREMENT attribute

Which parameter in MySQL configures the maximum number of connections that can be handled simultaneously by the server?

• A.innodb_max_connections
• B.max_connections
• C.thread_cache_size
• D.max_threads

How can you disable binary logging for a MySQL session?

• A.SET SQL_LOG_BIN = 0
• B.SET BIN_LOG = OFF
• C.SET BINLOG_LOGGING = 0
• D.SET BINLOG_DISABLE = 1

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

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