1z0-908 Exam Dumps - Oracle MySQL Database Administration Questions and Answers

20

24

21

25

22

6

MyISAM

NDB

MEMORY

ARCHIVE

InnoDB

It will force the load of the audit plugin even in case of errors at server start.

It causes the audit log to be created if it does not exist.

It prevents the audit plugin from being removed from the running server.

It prevents the audit log from being removed or rotated.

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

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

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

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

They are backups taken from snapshots of a running database.

They are backups taken from OS copy commands.

They are good to use if only data structures must be backed up but not log files.

They are good to use when many users are online accessing the database.

DESCRIBE manufacturing.parts;

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

SHOW INDEXES FROM manufacturing.parts;

SELECT * FROM information_schema.COLUMN_STATISTICS;

EXPLAIN SELECT INDEXES FROM manufacturing.parts;

QN = 3

QN = 5

QN = 1

QN = 4

QN = 2

sort_buffer_size

key_buffer_size

table_open_cache

read_buffer_size

innodb_buffer_pool_size

tmp_table_size

dba.configureInstance()

cluster.setPrimaryInstance()

dba.configureLocalInstance()

cluster.forceQuorumUsingPartitionOf()

cluster.addInstance()

dba.createCluster()

dba.checkInstanceConfiguration()

MySQL writes SDI to the binary log for distributed backups.

MySQL keeps InnoDB metadata changes in .sdi files in datadir.

The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.