Weekend Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Examstrust Logo
examstrust mcafee
  1. Home
  2. Oracle
  3. MySQL Database Administration
  4. 1z0-888 - MySQL 5.7 Database Administrator

Oracle 1z0-888 MySQL 5.7 Database Administrator Exam Practice Test

Page: 1 / 12
Total 124 questions
Get 1z0-888 Full Access Download 1z0-888 PDF

MySQL 5.7 Database Administrator Questions and Answers

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Add to Cart
Question 1

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

Options:

A.

using SSL when transporting data over remote networks

B.

using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

C.

setting --skip-networking when remote connections are not required

D.

setting specific GRANT privileges to limit remote authentication

E.

setting --mysql_secure_configuration to enable paranoid mode

Question 2

You created a backup of the world database with this command:

shell> mysqldump --opt world > dump.sql

Which two will import the data from dump.sql? (Choose two.)

Options:

A.

shell> mysqladmin recover test dump.sql

B.

shell> mysql test < dump.sql

C.

shell> mysqlimport test dump.sql

D.

mysql> USE test;

mysql> LOAD DATA INFILE ‘dump.sql’;

E.

mysql>USE test;

mysql>SOURCE dump.sql;

Question 3

Which statement is correct about how InnoDB storage engine uses disk space?

Options:

A.

It stores data in .MYD files and its index and undo information in the common tablespace.

B.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

C.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

D.

It stores its data, index and undo information in .MYD and .MYI files.

E.

It stores data, index and undo information in tablespace file(s).

Question 4

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

Options:

A.

Bob has max_user_connections set to zero, which blocks all his connections.

B.

All users are blocked because max_user_connections is accumulated over the host account information.

C.

connect_timeout is too small to allow a connection to occur.

D.

Joe has exceeded the max_user_connections global limit.

E.

Kay is already connected elsewhere and attempting to log in again.

Question 5

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.

Which statement describes the activation of that access for the user?

Options:

A.

The access does not take effect until the user logs out and back in.

B.

The access does not take effect until the next time the server is started.

C.

The access is available immediately.

D.

The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Question 6

You have a server that has very limited memory but has a very large table.

You will use mysqldump to back up this table.

Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

Options:

A.

--tab

B.

--single-transaction

C.

--quick

D.

--skip-buffer

Question 7

Is it true that binary backups always take less space than text backups?

Options:

A.

Yes, because binary backups only contain data, and not statements required to insert data into the tables.

B.

No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.

C.

No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.

D.

Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.

Question 8

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.)

Options:

A.

You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

B.

The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

C.

The statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.

D.

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.

E.

Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Question 9

Which statement best describes the purpose of the InnoDB buffer pool?

Options:

A.

It is amount of buffers available during a transaction.

B.

It caches only the indexes for InnoDB tables.

C.

It caches data and indexes for InnoDB tables.

D.

It holds changes made during a transaction before they are written to the log.

E.

It is a pool of memory for SQL query sort operations from within the InnoDB engine.

Question 10

Consider:

Which statement best describes the meaning of the value for the key_len column?

Options:

A.

It shows how many bytes will be used from each index row.

B.

It shows the number of characters indexed in the key.

C.

It shows the total size of the index row.

D.

It shows how many columns in the index are examined.

Question 11

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.

The colleague instant messages you this command:

mysql> SET SESSION max_connections = 200;

Why does the command fail?

Options:

A.

max_connections requires the GLOBAL scope.

B.

Its current user does not have the SUPER privilege.

C.

max_connections is not a dynamic variable. You need to change the config file and restart the database.

D.

Users can control only the max_user_connections variable.

Question 12

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

Options:

A.

InnoDB never uses table-level locks.

B.

InnoDB always protects auto-increment updates with a table-level lock

C.

InnoDB does not use locks to enforce auto-increment uniqueness.

D.

The auto-increment lock can be a table-level lock.

E.

Some settings for innodb_autoinc_lock_mode can help reduce locking.

Question 13

Where does MySQL Linux RPM install the mysqld binary?

Options:

A.

/usr/libexec/

B.

/usr/local/mysql/bin/

C.

/usr/sbin/

D.

/usr/bin/

E.

/opt/mysql/server/bin/

Question 14

Which statement describes how the relay log works?

Options:

A.

when a slave receives a change from the master, it is processed first, and then recorded in the relay log.

B.

It maintains a record of available master binary logs and the current executed log position.

C.

It stores changes on the master, and relays them to the slave.

D.

When a slave receives a change from the master, it is recorded in the relay log first and processed later.

Question 15

While attempting to set up a new replication slave on host ‘192.168.0.25’ with the user ‘replication’, you encounter this error:

What should you do to resolve this error?

Options:

A.

Add the user replication@192.168.0.25 with the correct password to the master.

B.

Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

C.

Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

D.

Add the user replication@192.168.0.25 with the correct password to the slave.

Question 16

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.)

Options:

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

Question 17

You back up by using mysqldump.

Which configuration is required on the MySQL Server to allow point-in-time recovery?

Options:

A.

binlog_format=STATEMENT

B.

log-bin

C.

apply-log

D.

bonlog_format=ROW

E.

gtid_enable

Question 18

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.

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:

A.

The slave has two intermediate relay slaves connected to it.

B.

The slave is configured with slave_parallel_workers = 4

C.

At most, two schemas are being updates concurrently.

D.

THREAD_ID 21 has stopped running.

E.

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

F.

The server needs more cores to use all slave threads.

Load More 1z0-888 Questions
Page: 1 / 12
Total 124 questions
Get 1z0-888 Full Access Download 1z0-888 PDF