Online 1z0-888 Practice TestMore Oracle Products >

Free Oracle 1z0-888 Exam Dumps Questions

Oracle 1z0-888: MySQL 5.7 Database Administrator

- Get instant access to 1z0-888 practice exam questions

- Get ready to pass the MySQL 5.7 Database Administrator exam right now using our Oracle 1z0-888 exam package, which includes Oracle 1z0-888 practice test plus an Oracle 1z0-888 Exam Simulator.

- The best online 1z0-888 exam study material and preparation tool is here.

4.5

(6165 ratings)

Question 1

You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema. Total dataset size is 200G with an average schema size G.
The data is transient and is not backed up and can be repopulated easily. Performance and responsiveness of the DB is paramount.
The query pattern for the DB instance is split 90/10 read/write. DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts. Which four configuration file edits might your colleague have performed to cause the negative DB performance?

A. table_open_cache = 64

B. innodb_buffer_pool_instances=64 innodb_buffer_pool_size=200G

C. log_bin=mysql –bin Innodb_flush_log_at_trx_commit=1

D. sync_binlog=10

E. innodb_flush_method=O_DIRECT

F. max_heap_table_size = 2G tmp_table_size=2G

G. query_cache_size = 2G query_cache_enabled=1

H. innodb_flush_log_at_trx_commit=0

Correct Answer:ABEG

Question 2

Examine the mydata table and SELECT statements:
1Z0-888 dumps exhibit
You issue: mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

A. one

B. one row and a next-key lock for supremum

C. one row and a gap-lock

D. five

Correct Answer:D

Question 3

Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

A. Set isolation level to be SERIALIZABLE.

B. Use the binary log row format.

C. Set isolation level to be READ COMMITTED.

D. Configure IPv6 network for hosts.

E. Guarantee a secondary index on every table.

F. Guarantee a primary key on every table.

G. Set multiple slave parallel worker thread

Correct Answer:ABF

Question 4

A MySQL database uses all InnoDB tables and is configured as follows;
1Z0-888 dumps exhibit
You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

A. --skip-opt

B. --lock-all-tables

C. --create-apply-log

D. --single-transaction

E. --master-data

Correct Answer:AB

Question 5

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

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

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

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

D. It is a shared-nothing architectur

Correct Answer:A

Question 6

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server: Master:
1Z0-888 dumps exhibit
Slave:

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

A. The log_bin variable is set to OFF on the slave.

B. server_id is not unique.

C. The max_connections variable on the slave needs to be increased.

D. The shared_memory_base_name variable must match the master.

E. The version of the slave is newer that the version of the maste

Correct Answer:A

START 1z0-888 EXAM