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

A. CHAR can store longer strings than VARCHAR

B. CHAR is variable-length, and VARCHAR is fixed-length

C. CHAR is fixed-length, and VARCHAR is variable-length

D. CHAR stores binary data, and VARCHAR stores text

A. MySQL Dump

B. MySQL Shell

C. MySQL Workbench Backup Utility

D. MySQL Enterprise Backup

A. BOOLEAN

B. VARCHAR

C. TINYINT

D. ENUM

A. Enabling transaction logs

B. Storing binary data in tables

C. Writing binary logs for replication

D. Caching of SELECT queries

A. To track uncommitted changes and allow rollback if needed

B. To store data modifications made by SELECT statements

C. To store query results for future reference

D. To ensure data replication between master and slave servers

A. CREATE DATABASE db_name CHARSET 'utf8';

B. CREATE DATABASE db_name CHARSET=utf8;

C. CREATE DATABASE db_name DEFAULT CHARSET 'utf8';

D. CREATE DATABASE db_name DEFAULT CHARSET=utf8;

A. By integrating with external systems like LDAP and Active Directory for centralized authentication

B. By enabling automatic backups of database tables

C. By optimizing database query performance

D. By encrypting data in real time

A. Star replication

B. Circular replication

C. Primary-replica replication

D. Multi-primary replication

A. GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'host';

B. GRANT SELECT, INSERT ON *.* TO 'user'@'host';

C. GRANT SELECT, INSERT ON database_name.* TO 'user'@'host';

D. GRANT ALL PRIVILEGES TO 'user';

A. It is a backup system for the cluster

B. It is the process of manually promoting a replica

C. It is a majority of nodes needed to commit a transaction

D. It is a set of SQL queries used for replication

A. Incremental backup

B. Full backup

C. Logical backup

D. Cold backup