1Z0-908 無料問題集「Oracle MySQL 8.0 Database Administrator」

（A）ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

（B）ALTER TABLE world.city ADD INDEX (Population);

（C）ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

（D）ALTER TABLE world.city ADD INDEX (Name);

（E）ALTER TABLE world.city ADD SPATIAL INDEX (Population);

（F）ALTER TABLE world.city ADD SPATIAL INDEX (Name);

（A）ALTER USER user -
IDENTIFIED WITH caching_sha2_password
BY 'password';

（B）ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

（C）ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';

（D）[mysqld]
default_authentication_plugin=mysql_native_password

（E）[mysqld]
default_authentication_plugin=caching_sha2_password

（F）[mysqld]
default_authentication_plugin=sha256_password

（A）The mysqlcheck --optimize --all-databases command reclaims free space from table files.

（B）The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

（C）The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

（D）The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

（E）The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

（A）It decrypts data for use in memory.

（B）It does not support the transportable tablespaces feature.

（C）It supports only non-blob datatypes.

（D）It enforces encryption from disk to memory and over network transmission.

（E）It supports all indexes transparently.

（A）It supports backing up only table structures.

（B）It supports restoring to a remote MySQL system.

（C）It supports the creation of incremental backups.

（D）It supports backup of a remote MySQL system.

（E）It creates logical backups.

（F）It can perform hot or warm backups.

（A）It can be used to create and edit SSL certificates and log locations.

（B）It provides an interface to change my.cnf files.

（C）It manages the configuration of client programs.

（D）It can move datadir to a new location.

（E）It will use [client] options by default unless you provide --login-path.

（F）It manages the configuration of the MySQL Firewall feature.

（G）It manages the configuration of user privileges for accessing the server.