Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-888 - MySQL 5.7 Database Administrator

Oracle 1z0-888 Premium Access     Download Demo    
Page: 3 / 4
Total 124 questions

You need to dump the data from the master server and import it into a new slave server.

Which mysqldump option can be used when dumping data from the master server in order to include the master server’s binary log information?

A.

include-log-file

B.

master-binlog

C.

include-master-info

D.

master-data

How does the InnoDB storage engine handle deadlocks when they are detected?

A.

Both the affected transactions will be rolled back.

B.

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

C.

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

D.

The transaction isolation level determines which transaction is rolled back.

E.

The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Consider the join_buffer_size parameter in MySQL Server.

Which two statements are true about the join buffer? (Choose two.)

A.

The value should be increased if the client performs several SELECT operations.

B.

The join buffer is set per connection.

C.

The join buffer is used to process sorts when complex joins are being performed.

D.

The value should be increased from the default if the query joins large rows without using an index.

E.

The join buffer is global and can be changed only by restarting the server.

A MySQL replication slave is set up as follows:

    Uses all InnoDB tables

    Receives ROW-based binary logs

    Has the read-only option

The replication slave has been found in an error state.

You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

A.

The applications have the SUPER privilege, which allows them to update rows.

B.

The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

C.

For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

D.

The slave was created with mysqldump –u root –p --skip-lock-tables –all-databases > /data/data.sql

E.

The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.

You start to restore your backup with this command;

shell> mysql –u root –p < backup.sql

After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.

Which is the most likely explanation for this slowdown?

A.

The MySQL server has stopped inserting data to check index consistency.

B.

InnoDB is doing CRC32 checks over the tablespace data as it grows.

C.

The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.

D.

InnoDB has filled the redo log and now must flush the pages.

E.

Secondary indexes no longer fit into the buffer pool.

You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.

The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

A.

Key Buffer Size

B.

InnoDB Redo Log Size

C.

Binary Log Size

D.

Buffer Pool Size

E.

Sort Buffer size

F.

Query Cache Size

Which three options are most likely to be changed for production form their default values? (Choose three.)

A.

innodb_buffer_pool_size

B.

max_connections

C.

join_buffer_size

D.

character_set_system

E.

innodb_log_file_size

F.

max_user_connections

G.

port

You are remotely logged in to MySQL as the user “backup”.

The account has temporarily been granted full privileges WITH GRANT to perform the actions required.

You want to change the password for the locally existing “backup” user.

Select the three commands which will perform the required action. (Choose three.)

A.

SET PASSWORD FOR ‘backup’@’localhost’ = ‘password’;

B.

SET PASSWORD = ‘password’;

C.

SET PASSWORD FOR ‘backup’@’localhost’ = PASSWORD (‘password’)

D.

ALTER USER USER() IDENTIFIED BY ‘password’;

E.

CREATE USER ‘backup’@’localhost’ IDENTIFIED BY ‘password’;

F.

ALTER USER ‘backup’ IDENTIFIED BY ‘password’;

G.

ALTER USER ‘backup’@’localhost’ IDENTIFIED BY ‘password’;

You enable binary logging on MySQL Server with the configuration:

binlog-format=STATEMENT

log-bin

Which database updates are logged on the master server to the binary log by default?

A.

all updates except to the TEMPDB database

B.

all updates except to the PERFORMANCE_SCHEMA database

C.

all updates not involving temporary tables

D.

all updates to the default database, except temporary tables

E.

all updates to all databases

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?

A.

MySQL starts and Binary Logging is enabled.

B.

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

C.

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

D.

MySQL starts but Binary Logging is disabled.