Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-908 - MySQL 8.0 Database Administrator

Page: 1 / 5
Total 140 questions

You have configured GTID-based asynchronous replication with one master and one slave.

A user accidentally updated some data on the slave.

To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

A.

RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

B.

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;

C.

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;

D.

RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;

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;

All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.

You must configure InnoDB Cluster to use SSL for group communication.

Which two statements are true? (Choose two.)

A.

SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).

B.

Configuring SSL group communication also configures SSL distributed recovery.

C.

An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.

D.

SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.

E.

If only some InnoDB Cluster members are enabled for SSL group communication, and --ssl-mode=PREFERRED, communication will fall back to unencrypted connection.

F.

SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

A.

It supports backing up only table structures.

B.

It can perform hot or warm backups.

C.

It creates logical backups.

D.

It supports the creation of incremental backups.

E.

It supports backup of a remote MySQL system.

F.

It supports restoring to a remote MySQL system.

Examine this command, which executes successfull

mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full

copy-back

Which statement is true about the copy-back process?

A.

The copy-back process is used to overwrite a new backup over an existing backup.

B.

It restores files from the data directory to their original MySQL server locations.

C.

It restores files from the backup directory to their original MySQL server locations.

D.

The copy-back process makes inconsistent backups.

Examine this command and output:

Which two statements are true? (Choose two.)

A.

The lock is at the metadata object level.

B.

The lock is a shared lock.

C.

The lock is an intentional lock.

D.

The lock is at the table object level.

E.

The lock is a row-level lock.

F.

The lock is an exclusive lock.

A user wants to connect without entering his or her username and password on the Linux command prompt.

Which three locations can be used to store the user’s mysql credentials to satisfy this requirement? (Choose three.)

A.

$HOME/.my.cnf file

B.

$MYSQL_HOME/my.cnf file

C.

DATADIR/mysqld-auto.cnf file

D.

$HOME/.mylogin.cnf file

E.

$HOME/.mysql/auth/login file

F.

/etc/my.cnf file

G.

$HOME/.mysqlrc file

Examine this query:

What information does this query provide?

A.

total memory used across all connections associated with the user on connection number 10

B.

total memory used by the first 10 connections

C.

total memory used by thread number 10

D.

total memory used across all connections associated with the user on thread number 10

E.

total memory used by connection number 10

F.

total memory used by the first 10 threads

How can mysql_multi be configured to allow MySQL instances to use the same port number?

A.

The instances use different user accounts unique to each instance.

B.

The instances listen on different IP addresses.

C.

The instances use different socket names.

D.

The instances have appropriate net masks set.

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.

Which command will back up the databases in parallel?

A.

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

B.

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

C.

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

D.

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

You want to dump all databases with names that start with "db".

Which command will achieve this?

A.

mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

B.

mysqlpump > all_db_backup.sql

C.

mysqlpump --include-databases=db --result-file=all_db_backup.sql

D.

mysqlpump --include-databases=db% --result-file=all_db_backup.sql