Oracle MySQL 8.0 Database Administrator - 1z1-908 Free Exam Questions

A. monitoring the availability of the MySQL instance

B. tracing import and export with mysqidump

C. analyzing executed MySQL queries

D. creating e-mail alerts and SNMP traps for MySQL warnings

E. deploying the MySQL agent on supported target operating system

F. starting and stopping the MySQL instance

G. monitoring of NDB Cluster API nodes

A. John has not activated the role.

B. The statement was blocked by MySQL Firewall.

C. The DBA needs to execute FLUSH PRIVILEGES.

D. John needs to reconnect to the database.

A. You must manually initialize the data directory.

B. MySQL uses the RPM relocatable installation target feature.

C. The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

D. You can provide the root password interactively.

E. You can find the root password in the error log after the first start.

F. The functionality is split among several RPM package files.

A. Physical upgrades are much faster because they do not require restarting the mysqld process.

B. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

C. Logical upgrades are much faster because they do not require restarting the mysqld process.

D. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.

E. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.

F. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.

A. DESCRIBE manufacturing.parts;

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

C. EXPLAIN SELECT INDEXES FROM manufacturing.parts;

D. SELECT * FROM information_schema.COLUMN_STATISTICS;

E. SHOW INDEXES FROM manufacturing.parts;

A. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

B. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

C. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

D. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

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

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

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

A. It can be protected with a password.

B. It can be dropped using the DROP ROLE statement.

C. It can be renamed using the RENAME ROLE statement.

D. It can be granted to user accounts.

E. It is created as a locked account.

F. It is stored in the mysql.role table.

A. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql

C. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql

D. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql