최신Oracle MySQL Implementation Associate - 1Z1-922무료샘플문제

A. Asynchronous replication

B. Statement-based replication

C. Group replication

D. Semi-synchronous replication

A. Backs up only the changes since the last backup

B. Restores the database from a previous backup

C. Backs up only the binary logs

D. Backs up only the database structure

A. mysqlbackup --restore

B. mysqlbinlog --restore

C. mysql < backup.sql

D. mysqldump --restore

A. INSERT privilege

B. SELECT privilege

C. RELOAD privilege

D. EXECUTE privilege

A. It automates the failover process

B. It handles user authentication

C. It manages query caching for high-performance environments

D. It provides a command-line interface to configure and manage the cluster

A. It grants a user the ability to pass on their privileges to others

B. It grants all privileges to a user

C. It removes all privileges from the user

D. It allows a user to modify their own privileges

A. Grant privileges with 'user'@'*.*'

B. Grant privileges with 'user'@'%'

C. Grant privileges with 'user'@'all_hosts'

D. Grant privileges with 'user'@'localhost'

A. MySQL Enterprise Backup

B. MySQL Enterprise Firewall

C. MySQL Shell

D. MySQL Dump

A. The next available node is promoted to primary

B. Replication switches to asynchronous mode

C. The cluster stops processing transactions

D. All nodes are automatically restored

A. Logical backup

B. Incremental backup

C. Binary log backup

D. Compressed backup

A. MySQL Enterprise Backup

B. MySQL Query Optimizer

C. MySQL Replication

D. Performance Schema

A. Role D.

B. Host User

C. Password

A. INSERT INDEX

B. ADD INDEX

C. CREATE INDEX

D. MODIFY INDEX

A. To accelerate analytic queries by reducing disk I/O

B. To reduce memory usage in large databases

C. To optimize data storage on disk

D. To enable replication across regions