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

（A）Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

（B）Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

（C）Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

（D）Look for queries with low total latency times in the Latency section in the times series graph.

（A）MEMORY

（B）InnoDB

（C）ARCHIVE

（D）NDB

（E）MyISAM

（A）change buffer

（B）doublewrite buffer

（C）user privileges

（D）primary indexes

（E）InnoDB Data Dictionary

（F）table data

（A）Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

（B）TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

（C）Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

（D）MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

（A）It is not mandatory that all instances are running and reachable before running the command.

（B）It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

（C）It reconfigures InnoDB Cluster if the cluster was stopped.

（D）It only starts all InnoDB Cluster instances.

（E）It performs InnoDB Cluster instances rolling restart.

（F）It only stops and restarts all InnoDB Cluster instances.

（G）It stops and restarts all InnoDB Cluster instances and initializes the metadata.

（A）ibbackup files

（B）ib_logfile* files

（C）*.ibd files

（D）*.CSM files

（E）*.sdi files

（A）This file is for storing MySQL server_uuid values only.

（B）This file is for storing MySQL Server configuration options in ISON format.

（C）It is read and processed at the beginning of startup configuration.

（D）This file is for logging purposes only and is never processed.

（E）It is read and processed at the end of startup configuration.

（F）It is always updated with changes to system variables.

（A）Connections driven by MySQL Router are not affected by the command.

（B）The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

（C）Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

（D）The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

（E）The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

（F）Group Replication will be dissolved and all metadata purged.

（A）The master is producing a large volume of events in parallel but the slave is processing them serially.

（B）The master is most probably too busy to transmit data and the slave needs to wait for more data.

（C）This value shows only I/O latency and is not indicative of the size of the transaction queue.

（D）One or more large tables do not have primary keys.

（E）The parallel slave threads are experiencing lock contention.

（A）It provides a uniform installation wizard across multiple platforms.

（B）It installs most Oracle MySQL products.

（C）It provides only GUI-driven, interactive installations.

（D）It performs product upgrades.

（E）Manual download of separate product packages is required before installing them through MySQL Installer.