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: 2 / 5
Total 140 questions

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

A.

recording the order in which queries are issued

B.

audit of all queries

C.

point-in-time recovery

D.

replication

E.

logging the duration and locks for all queries

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

A.

Enable GTID by executing this on the master and the slave:

SET GLOBAL GTID_ENABLED=on;

B.

Execute this on the slave to enable GTID:

START SLAVE IO_THREAD WITH GTID;

C.

Restart MySQL (master and slave) with these options enabled:

--gtid_mode=ON

--log-bin

--log-slave-updates

--enforce-gtid-consistency

D.

Execute this on the slave to enable GTID:

RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

E.

On the slave, alter the MySQL master connection setting with:

ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F.

On the slave, alter the MySQL master connection setting with:

CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A.

The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B.

It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C.

It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D.

It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E.

It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Which two methods allow a DBA to reset a user's password? (Choose two.)

A.

ALTER USER statement

B.

mysql_secure_installation utility

C.

SET PASSWORD statement

D.

mysqladmin client program

E.

GRANT statement

You are using an existing server with a new configuration. MySQL Server fails to start.

Examine this snapshot of the error log:

Which action would allow the server to start?

A.

Remove ib_logfile0 and ib_logfile1 files from the file system.

B.

Execute mysqladmin flush-logs.

C.

First run mysqld --initialize to refresh the Size of ib_logfile.

D.

Create a new ib_logfile0 file of size 26214400.

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.

Which two statements are true? (Choose two.)

A.

The instance deployed on host2 is elected as the new primary instance.

B.

The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

C.

The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

D.

Failure of the instance deployed on host1 provokes an outage.

E.

The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

F.

The primary instance can be specified by using the command cluster.setPrimaryInstance(:).

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.

Your goal is to decrease the amount of data that is transferred between these two hosts.

It is confirmed that the slave instance does not need to have data from the example database.

Which replication filter contributes to your goal?

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

An attempt to recover an InnoDB Cluster fails.

Examine this set of messages and responses:

host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage…

The instance ‘host1:3377'’ was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y

The instance ‘host2:3377’ was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y

Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError)

Which statement is true?

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.

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

D.

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

E.

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

You are using mysqlcheck for server maintenance.

Which two statements are true? (Choose two.)

A.

The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B.

The mysqlcheck --optimize --all-databases command reclaims free space from table files.

C.

The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D.

The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

E.

The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

A.

GRANT ALL PRIVILEGES ON ‘world’.‘city’ TO ‘tom’@’%’;

GRANT SELECT (‘code’) ON ‘world’.‘country’ TO ‘tom’@’%’;

B.

GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;

GRANT ALL PRIVILEGES ON ‘world’.‘country’ TO ‘tom’@’%’;

C.

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

D.

GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’; GRANT SELECT ON ‘world’.‘country’ TO ‘tom’@’%’;