先試後買

A. MySQL Enterprise No-Login Authentication

B. MySQL Enterprise Data Masking and De-identification

C. MySQL Enterprise Transparent Data Encryption (TDE)

D. MySQL Enterprise Audit

E. MySQL Enterprise Scalability

A. Create user by using CREATE USER 'newuser'@'localhost' IDENTIFIED WITH 'Sh@256Pa33';

B. Add --default_authentication_plugin=sha256_password on the command line when you invoke the server.

C. Add default_authentication_plugin=sha256_password under [mysqld] in the configuration file.

D. Create user by using CREATE USER 'newuser' @'localhost' SET PASSWORD AS 'Sh@256Pa33';

A. ALTER TABLE city LESS population;

B. ALTER TABLE city DROP population;

C. ALTER TABLE city DELETE population;

D. DELETE population FROM city;

E. DROP population FROM city;

A. Data Modeling Import Export Wizard

B. Binary Data Export and Import Wizard

C. Backup Data Export and Import Wizard

D. SQL Data Export and Import Wizard

E. Table Data Export and Import Wizard

F. Result Data Export and Import

A. It provides the ability to create incremental backups.

B. It enables you to take non-locking backups.

C. It cannot back up encrypted tablespaces.

D. It performs hot or warm backups.

E. It performs logical backups.

A. exporting data faster with mysqldump

B. increasing performance when using select statements

C. to make it easier to change the PRIMARY KEY value

D. maintaining a history of row insertions or updates

E. preventing duplicate keys

F. automatic storage of data in a sorted order

A. The MASTER and SLAVE are grouped as one instance for monitoring.

B. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

C. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

D. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

E. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.