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

Page: 1 / 4

Questions 4

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

Options:

The server will crash.

The server suspends that INSERT operation until space becomes available.

An error message will be returned to the client .Server Error: ER_IO

The server suspends operations for all storage engines until space becomes available.

Buy Now

Questions 5

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:

Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

Options:

The log_bin variable is set to OFF on the slave.

server_id is not unique.

The max_connections variable on the slave needs to be increased.

The shared_memory_base_name variable must match the master.

The version of the slave is newer that the version of the master.

Buy Now

Questions 6

The /myfolder/my.cnf file has option set:

[mysqld]

skip-log-bin

/myfolder2/my.cnf has this option set:

[mysqld]

log-bin = /valid/path/to/mysqlbinlog

All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.

You start an instance by using this command line:

mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf

What is the outcome?

Options:

MySQL starts and Binary Logging is enabled.

MySQL fails to start due to the conflicting options in the configuration files.

MySQL fails to start due to conflicting options on the command line.

MySQL starts but Binary Logging is disabled.

Buy Now

Questions 7

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)