최신Oracle MySQL 8.0 Database Administrator - 1Z0-908무료샘플문제

A. QN = 4

B. QN = 1

C. QN = 2

D. QN = 5

E. QN = 3

A. ALTER USER 'joe'@'%' SET password='*invalid*'

B. ALTER USER 'joe'@'%' ACCOUNT LOCK

C. ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

D. ALTER USER 'joe'@'%' PASSWORD HISTORY 0

E. REVOKE USAGE ON *.* FROM 'joe'@'%'

F. REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'

A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.

B. The cluster is running and there is at least one ONLINE instance.

C. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

D. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').

E. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').

A. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

B. A small amount of committed transactions may be lost in case they were committed just before the disk failure.

C. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

D. No committed transactions are lost.

E. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.

F. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

A. Look for queries with low total latency times in the Latency section in the times series graph.

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 low Query Response Time index (QRTi) values.

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

A. It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

B. It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

C. It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.

D. It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

A. on slave: --replicate-wild-ignore=example.%

B. on slave: --replicate-ignore-db=example

C. on master: --replicate-ignore-db=example

D. on master: --binlog-ignore-db=example

E. on slave: --binlog-ignore-db=example

A. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

B. Connections driven by MySQL Router are not affected by the command.

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 the instance where the connection was established.

E. Group Replication will be dissolved and all metadata purged.

F. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

A. shell> mysql --print-defaults

B. shell> mysqld --help --verbose

C. shell> mysqladmin --debug

D. mysql> SHOW GLOBAL VARIABLES;