최신 1z1-908 무료덤프 - Oracle MySQL 8.0 Database Administrator

A. Remove world read privileges from the server-cert.pem certificate file.

B. Remove the world read/execute privilege from the accounting directory.

C. Change the group ownership of the mysql directory to the mysql user group.

D. Remove world read privileges from the public_key.pem file.

E. Remove group read/write privileges from the private_key.pem file.

F. Change the parent directory owner and group to mysql.

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

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

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

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. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

C. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

D. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

A. SELECT * FROM information_schema.COLUMN_STATISTICS;

B. SELECT * FROM information_schema.statistics WHERE table_schema='manufacturing' AND TABLE_NAME='parts';

C. SHOW INDEXES FROM manufacturing.parts;

D. EXPLAIN SELECT INDEXES FROM manufacturing.parts;

E. DESCRIBE manufacturing.parts;

A. It reads the relay log and executes the events contained in them.

B. It connects to the master and asks it to send updates recorded in its binary logs.

C. It monitors and schedules the rotation/deletion of the binary logs.

D. It acquires a lock on the binary log for reading each event to be sent to the slave.

A. ALTER TABLE world.city ADD SPATIAL INDEX (Population);

B. ALTER TABLE world.city ADD INDEX (Population);

C. ALTER TABLE world.city ADD INDEX (Name);

D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

F. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

A. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

B. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

C. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

D. InnoDB tablespaces outside the datadir are able to be cloned.

E. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

F. It is always slower than {recoveryMethod: 'incremental'}.

A. It performs InnoDB Cluster instances rolling restart.

B. It only stops and restarts all InnoDB Cluster instances.

C. It stops and restarts all InnoDB Cluster instances and initializes the metadata.

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

E. It reconfigures InnoDB Cluster if the cluster was stopped.

F. It is not mandatory that all instances are running and reachable before running the command.

G. It only starts all InnoDB Cluster instances.

A. mysql

B. world

C. sys

D. employee

E. information_schema

A. $MYSQL_HOME/my.cnf file

B. DATADIR/mysqld-auto.cnf file

C. $HOME/.mysql/auth/login file

D. $HOME/.mysqlrc file

E. $HOME/.my.cnf file

F. $HOME/.mylogin.cnf file

G. /etc/my.cnf file