Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free 1z0-908 Oracle Updates

Page: 3 / 5
Total 140 questions

MySQL 8.0 Database Administrator Questions and Answers

Question 9

You have configured MySQL Enterprise Monitor to monitor your MySQL server.

Which four features are available? (Choose four.)

Options:

A.

starting and stopping the MySQL instance

B.

tracing import and export with mysqidump

C.

deploying the MySQL agent on supported target operating system

D.

creating e-mail alerts and SNMP traps for MySQL warnings

E.

monitoring the availability of the MySQL instance

F.

analyzing executed MySQL queries

G.

monitoring of NDB Cluster API nodes

Question 10

Examine these statements, which execute successfully:

TRUNCATE test; BEGIN;

INSERT INTO test(id, name) VALUES(1, “Hello”); ROLLBACK;

SELECT id FROM test;

Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

Options:

A.

NDB

B.

ARCHIVE

C.

InnopB

D.

BLACKHOLE

E.

MEMORY

F.

MyISAM

Question 11

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

Options:

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

Question 12

Which three statements are true about MySQL replication? (Choose three.)

Options:

A.

Replication can use only TCP/IP connections.

B.

Any instance can have multiple slaves, but it can have only one master.

C.

Each instance in a replication topology must have a unique server ID.

D.

Binary logs contain only transactions originating from a single MySQL instance.

E.

Each slave must have its own MySQL user for replication.

F.

Binary logging must be enabled on the master in order to replicate to other instances.

G.

A replication user must have the SELECT privilege for all tables that need to be replicated.

Page: 3 / 5
Total 140 questions