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

（A）MEMORY

（B）InnoDB

（C）ARCHIVE

（D）NDB

（E）MyISAM

（A）total memory used by the first 10 threads

（B）total memory used by connection number 10

（C）total memory used across all connections associated with the user on connection number 10

（D）total memory used across all connections associated with the user on thread number 10

（E）total memory used by the first 10 connections

（F）total memory used by thread number 10

（A）any user created without a password

（B）any new ROLE accounts

（C）any internal system accounts

（D）any user set as DEFINER for stored programs

（E）any user created with a username, but missing the host name

（A）mysqladmin client program

（B）mysql_secure_installation utility

（C）ALTER USER statement

（D）SET PASSWORD statement

（E）GRANT statement

（A）The user is authorized as the accounting@localhost user.

（B）The user is authorized as the rsmith@localhost user.

（C）The user failed to define a username and the connecting username defaulted to ''@'%'.

（D）The user is logged in with --user=accounting as an option.

（E）The user is authenticated as the anonymous proxy user ''@'%'.

（A）MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.

（B）MySQL Router is restarted.

（C）MySQL Router is configured based on the information in files in directory_path.

（D）MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

（A）mysqlpump --include-databases=db% --result-file=all_db_backup.sql

（B）mysqlpump --include-databases=db --result-file=all_db_backup.sql

（C）mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

（D）mysqlpump > all_db_backup.sql

（A）redo tablespaces

（B）data tablespaces

（C）schema tablespaces

（D）undo tablespaces

（E）encryption tablespaces

（F）temporary table tablespaces

（A）basing expected growth on an average of the last 3 years

（B）buying more disk

（C）adding circular replication nodes for increased DML capability

（D）monitoring OS resources for patterns

（E）buying more CPU

（F）consulting the application team about any future projects and use

（G）upgrading to the latest application version

（H）buying more RAM

（A）The backup operation will finish only when backup-and-apply-log is executed.

（B）A single-file backup is created.

（C）The --backup-dir option holds temporary output, status, and metadata files.

（D）The backup operation will finish only when apply-log is executed.

（E）A raw backup is created.