Pass the Oracle MySQL Database Administration 1z0-888 Questions and answers with CertsForce

when a slave receives a change from the master, it is processed first, and then recorded in the relay log.

It maintains a record of available master binary logs and the current executed log position.

It stores changes on the master, and relays them to the slave.

When a slave receives a change from the master, it is recorded in the relay log first and processed later.

innodb_buffer_pool_size

max_connections

join_buffer_size

character_set_system

innodb_log_file_size

max_user_connections

port

allowing change of the server runtime configuration

allowing a client to shut down the server

allowing client accounts to take over the account of another user

allowing a client to kill other client connections

Use one-way encryption for storage of passwords.

Store passwords external to the database.

Choose short passwords to save on storage space.

Use simple keyboard actions that give mixed letters.

Do not use dictionary-based words.

Both the affected transactions will be rolled back.

The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

One of the affected transactions will be rolled back, the other is allowed to proceed.

The transaction isolation level determines which transaction is rolled back.

The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

mysqldumpslow

mysqldump

mysqlaccess

mysqlshow

mysqlslow

The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

All these tables have the same number of rows.

The global_status table is equivalent to the SHOW GLOBAL STATUS statement.

The variable values in status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.

The session_status table is equivalent to status_by_thread for the current thread.

There is network congestion between client and server.

No index has been defined on the filtered column.

There are 108 queries still being executed.

A table lock is causing delays.

A full table scan is being used.