Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
MySQL Database Administration
1z0-888
MySQL 5.7 Database Administrator Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-888 Premium Access

View all detail and faqs for the 1z0-888 exam

Go to Exam

694 Students Passed

94% Average Score

90% Same Questions

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Questions # 21:

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

Options:

It relies on the shared disk architecture being visible to both servers.

It is provided by means of IP-level disk replication.

It implements High Availability by using the .NET Connector’s load balancing capabilities.

It is a shared-nothing architecture.

Answer

Questions # 22:

You are investigating the performance of a query which selects data from an InnoDB table.

Consider this Performance Schema diagnostics output for the query:

Question # 22

Which statement is true about the output?

Options:

The time the query took is the sum of all timer_wait values.

The query did not find its table in the table definition cache.

The query read data from the data file rather than directly from the buffer pool.

The event with event_id = 8945 is a child of the event with event_id=8944.

Answer

Questions # 23:

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.

Question # 23

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output? (Choose two.)

Options:

The slave has two intermediate relay slaves connected to it.

The slave is configured with slave_parallel_workers = 4

At most, two schemas are being updates concurrently.

THREAD_ID 21 has stopped running.

The slave cannot process the relay log fast enough to use all threads.

The server needs more cores to use all slave threads.

Answer

B, E

Questions # 24:

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

Options:

log-master-updates

rpl-recovery-rank

server-id

enable-master-start

log-bin

master-logging

Answer

C, E

Explanation

[Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql, ]

Questions # 25:

A crucial database, ‘db_prod’, just disappeared from your production MySQL instance.

In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:

SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’

Which three methods could have been used to prevent this SQL injection attack from happening? (Choose three.)

Options:

writing your client code to properly escape all user input

giving limited privileges to accounts used by application servers to interact with their backing databases

using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions

using a hashing or encryption method to secure all user passwords in your MySQL tables

removing any remaining anonymous accounts from your MySQL instance

validating all user input before sending it to the database server

changing all passwords for the MySQL account ‘root’@’%’ immediately after losing an employee who knew the current password

Answer

D, E, G

Questions # 26:

Consider the ANALYZE TABLE command.

In which two situations should this command be used?

Options:

when you want to check a tables structure to see if it may have been damaged and needs repair

when you need to find out why a query is taking a long time to execute

when you want to update index distribution statistics

after large amounts of table data have changed

Answer

C, D

Questions # 27:

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

Master:

Question # 27

Slave:

Question # 27

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.

Answer

Questions # 28:

You have created a backup of the ‘sales’ database with the command:

Question # 28

Which two procedures can be used to restore the ‘orders’ table from the backup?

Options:

Answer

B, C

Questions # 29:

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?

Options:

all updates except to the TEMPDB database

all updates except to the PERFORMANCE_SCHEMA database

all updates not involving temporary tables

all updates to the default database, except temporary tables

all updates to all databases

Answer

Questions # 30:

A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)