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

A. INFORMATION_SCHEMA.INNODB_TABLESTATS

B. SHOW TABLE STATUS;

C. SHOW STATUS;

D. INFORMATION_SCHEMA.INNODB_METRICS

E. SHOW ENGINE INNODB STATUS;

F. INFORMATION_SCHEMA.STATISTICS

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

B. It is the time between the most recent transaction written to the relay logs 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 applied by the SQL thread.

D. 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.

A. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

B. ALTER TABLE employees -
ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

C. ALTER TABLE employees -
ADD INDEX ((MONTH(birth_date)));

D. ALTER TABLE employees -
ADD INDEX (birth_date);

E. ALTER TABLE employees -
ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

F. ALTER TABLE employees -
ADD INDEX (birth_date DESC);

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

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

C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

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

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

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

A. ADMIN OPTION allows Mark to drop the role.

B. ADMIN OPTION causes the role to be activated by default.

C. Mark must connect from localhost to activate the r_read@localhost role.

D. Mark can grant the r_read@localhost role to another user.

E. Mark can grant the privileges assigned to the r_read@localhost role to another user.

F. Mark can revoke the r_read@localhost role from another role.

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

B. [mysqld]
default_authentication_plugin=caching_sha2_password

C. [mysqld]
default_authentication_plugin=sha256_password

D. ALTER USER user -
IDENTIFIED WITH mysql_native_password
BY 'password';

E. [mysqld]
default_authentication_plugin=mysql_native_password

F. ALTER USER user -
IDENTIFIED WITH sha256_password -
BY 'password';

A. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

B. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';

C. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';

D. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

E. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--';

F. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

A. /usr/mysql

B. /usr

C. /var/lib/mysql

D. /usr/bin

E. /etc/my.cnf

A. error log

B. general query log

C. audit log

D. binary log

E. slow query log

A. It uses only time-based replication conflict resolution.

B. It relies on relay_log_recovery for resilient operations.

C. It is not compatible with auto-positioning.

D. It must use GTID replication.

E. It does not attempt to detect or resolve replication conflicts.

F. It needs to be re-instanced after a crash to maintain consistency.