Oracle 1Z0-908 Quiz 1 Topic 4 Questions 1-5

Question: 1

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

Asort_buffer_size

Bkey_buffer_size

Ctable_open_cache

Dread_buffer_size

Einnodb_buffer_pool_size

Ftmp_table_size

Show Answer

Question: 2

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

Which command will back up the databases in parallel?

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

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

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

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

Show Answer

Question: 3

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.

Examine the output:

q3_1Z0-908

What statement is true about the start attempt?

AMySQL server was not started due to a problem while executing process 2732.

BMySQL server continued to start up even though another process existed.

Csystemd found the mysqld service disabled and failed to start it.

Dsystemd waited for 30 seconds before timing out and start up failed.

Esystemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Show Answer

Question: 4

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

ANDB

BARCHIVE

CInnopB

DBLACKHOLE

EMEMORY

FMyISAM

Show Answer

Question: 5

Which three requirements must be enabled for group replication? (Choose three.)

Aslave updates logging

Bsemi-sync replication plugin

Cprimary key or primary key equivalent on every table

Dbinary log checksum

Ebinary log ROW format

Fbinary log MIXED format

Greplication filters

Show Answer

Oracle 1Z0-908 Quiz:1 Topic:4 Questions:1-5