Free Download 1z0-888 Examp Dump: Oracle.1z0-888.PracticeTest.2018-09-19.38q.vcex

Question 1

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing.

Which step do you perform to create the contents of the data directory?

Run the create_system_tables.sql file
Run the mysql_unpack.sql file
Invoke mysqld with the --initialize option.
Invoke mysql with the --initialize option.

Correct answer: C

Explanation:

Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html

Question 2

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.

Which two methods would allow the mysql client to connect to the server and send clear text passwords?

mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
SET GLOBAL mysql_cleartext_passwords=1;
mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Correct answer: DE

Explanation:

Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html

Question 3

Which are three facts about backups with mysqldump?

will lock all storage engines for duration of backup
can back up a remote database server
allow a consistent backup to be taken
are able to back up specific items within a database
create automatically compressed backups
are always faster to restore than binary backups

Correct answer: BCD

Question 4

Consider the key buffer in a MySQL server. Which two statements are true about this feature?

It caches index blocks for MyISAM tables only.
It caches index blocks for all storage engine tables.
It is a global buffer.
It is set on a per-connection basis.
It caches index blocks for InnoDB tables only.

Correct answer: AD

Explanation:

Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer

Question 5

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

log-master-updates
rpl-recovery-rank
server-id
enable-master-start
log_bin
master-logging

Correct answer: CE

Explanation:

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

Question 6

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

UPDATE sales.january SET amount=amount+1000;

An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.

Which statement is true? (Choose two.)

You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
The statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.
Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Correct answer: DE

Question 7

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

innodb_buffer_pool_size
max_connections
join_buffer_size
character_set_system
innodb_log_file_size
max_user_connections
port

Correct answer: EFG

Question 8

What is the order of tables shown in an EXPLAIN output?

It lists tables from the smallest to the largest.
It lists tables in the order in which their data will be read.
It lists tables from the most optimized to the least optimized.
It lists tables in the order in which they are specified in the statement that is being explained.

Correct answer: D

Explanation:

Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html

Question 9

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

binlog_cache_size=1024 is too small and transactions are lost.
binlog_format=STATEMENT and a non-deterministic query was executed.
enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
The sync_relay_log=1000 setting on the slave is too small.
sync_binlog=0 and the master server crashed.

Correct answer: AC

Question 10

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?

The applications have the SUPER privilege, which allows them to update rows.
The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
The slave was created with mysqldump –u root –p --skip-lock-tables –all-databases > /data/data.sql
The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

Correct answer: CD

Exam	MySQL 5.7 Database Administrator
Number	1z0-888
File Name	Oracle.1z0-888.PracticeTest.2018-09-19.38q.vcex
Size	744 KB
Posted	Sep 19, 2018
Download	Oracle.1z0-888.PracticeTest.2018-09-19.38q.vcex

Download Oracle.1z0-888.PracticeTest.2018-09-19.38q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions