Free Download 1z0-888 Examp Dump: Oracle.1z0-888.TestInside.2019-07-13.42q.vcex

Question 1

Which three allocate memory per thread in MySQL? (Choose three.)

query cache
thread cache
read buffer
internal temporary table
sort buffer
InnoDB buffer pool instance

Correct answer: CEF

Explanation:

Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html

Question 2

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

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.

Correct answer: B

Question 3

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.

Which two are true about the login path feature? (Choose two.)

mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
A .mylogin.cnf file can store at most one login path.
It provides a FIPS-compliant keyring for storing MySQL login details.
A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
It is an alternative to storing the MySQL login details in a my.cnf file.
It provides means to help avoid accidentally exposing the MySQL login details.

Correct answer: EF

Explanation:

Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html

Question 4

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 5

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? (Choose two.)

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 6

Which are three facts about backups with mysqldump? (Choose three.)

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 7

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

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 8

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

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 9

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 10

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

innodb_buffer_pool_size
max_connections
join_buffer_size
character_set_system
innodb_log_file_size
max_user_connections
port

Correct answer: EFG

Exam	MySQL 5.7 Database Administrator
Number	1z0-888
File Name	Oracle.1z0-888.TestInside.2019-07-13.42q.vcex
Size	804 KB
Posted	Jul 13, 2019
Download	Oracle.1z0-888.TestInside.2019-07-13.42q.vcex

Download Oracle.1z0-888.TestInside.2019-07-13.42q.vcex

File Info

How to open VCEX & EXAM Files?

Demo Questions