Oracle 1Z0-908 問題集

質問 1：
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?
A. It defines all innodb tablespace options relative to a starting parent directory.
B. It allows scanning of other locations to discover more innodb tablespaces.
C. It adds more temporary workspace in addition to the innodb_tmpdir location.
D. It is not necessary because innodb_data_home_dir is already defined.
E. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
A. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
B. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
C. InnoDB tablespaces outside the datadir are able to be cloned.
D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
E. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
F. It is always slower than {recoveryMethod: 'incremental'}.
正解：A,E,F

質問 3：
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
A. access control lists
B. view definitions
C. server runtime configuration
D. performance metrics
E. server configuration rollback
F. stored procedure definitions
G. InnoDB buffer pool LRU management data
正解：B,C,D

質問 4：
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
A. Run mysqld with --datadir defined for each instance.
B. Use resource groups to lock different instances on separate CPUs.
C. Run MySQL Server docker containers.
D. Use systemd with different settings for each instance.
E. Use system tools to lock each instance to its own CPU.
F. Start mysqld or mysqld_safe using different option files for each instance.
正解：A,D,F

質問 5：
Which two methods allow a DBA to reset a user's password? (Choose two.)
A. GRANT statement
B. mysql_secure_installation utility
C. mysqladmin client program
D. SET PASSWORD statement
E. ALTER USER statement
正解：D,E