Labour Day Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Activedumpsnet Logo
  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

Question 1

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 2

Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?

Options:

A.

battery-backed locally-attached RAID 5 array

B.

iSCSI Lun

C.

SAN (Fibre Channel) Lun

D.

NFS (Networked File System) mount

Question 3

Consider:

Question # 3

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 4

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

Question # 4

What are the two most likely reasons for the slowness given this output? (Choose two.)

Options:

A.

Date should be a TIMESTAMP field for better performance.

B.

The User field is too long for most names.

C.

The engine type is not appropriate to the application use.

D.

Using default values for DATETIME causes table scans.

E.

No indexes are defined.

Question 5

In which order does MySQL process an incoming INSERT statement?

Options:

A.

It checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.

B.

It checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.

C.

It writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.

D.

It optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.

Question 6

There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.

The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.

A restore of the second instance is attempted from the mysqlbackup archive using this command:

mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back

Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

Options:

A.

--restore=2

B.

--copy-back-from-log

C.

--backup-instance=/var/lib/mysql/instance2

D.

--instance=/var/lib/mysql/instance2

E.

--defaults-file=/etc/mysql/instance2.cnf

Question 7

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 8

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.

Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Options:

A.

Implement a failover strategy to another geographic location.

B.

Create a master-master pair for each service.

C.

Have a second data centre in a different region or country.

D.

Keep software updated to the latest version.

E.

Use RAID 10 storage for data.

F.

Use on-site network-attached storage to separate service from data.

Question 9

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

Which 2 things should you investigate?

Options:

A.

Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

B.

Check the difference between the InnoDB status values “Log Sequence number” and “Last Checkpoint” positions then compare that to the total size of the redo log.

C.

Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

D.

Check the difference between the InooDB status values “Trx id counter” and “Purge done for” and compare to the state substatus of the main “Main thread”

E.

Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Question 10

A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?

Options:

A.

using GRANT … REQUIRE X509 AND REQUIRE ISSUER ‘/C=…..’ AND REQUIRE SUBJECT ‘/C=…..’

B.

using GRANT USAGE, X509, …….ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

C.

using GRANT … REQUIRE SSL for a secure connection

D.

using GRANT USAGE, SSL, …..ON *.* TO user@remotehost IDENTIFIED BY ‘secret_password’

Question 11

You are investigating the performance of the server and see this information:

  • events_waits_summary_global_by_event_name in the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events.
  • The Table_open_cache_overflows status variable is 0.

Which action should be taken to remove the performance bottleneck described here?

Options:

A.

Increase the value of table_open_cache_instances.

B.

Decrease the value of table_definition_cache.

C.

Decrease the value of table_open_cache.

D.

Increase the value of table_definition_cache.

E.

Increase the value of table_open_cache.

F.

Decrease the value of table_open_cache instances.

Question 12

Which two capabilities are granted with the SUPER privilege?

Options:

A.

allowing change of the server runtime configuration

B.

allowing a client to shut down the server

C.

allowing client accounts to take over the account of another user

D.

allowing a client to kill other client connections

Question 13

You are using GTIDS in replication. You need to skip a transaction with the GTID of aaa-bbb-ccc-ddd-eee:3 on a slave.

Which procedure would you execute from a MySQL prompt?

Options:

A.

Option A13

B.

Option B13

C.

Option C13

D.

Option D13

Question 14

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 15

Consider:

Question # 15

What does the range value in the type column mean?

Options:

A.

You can use an index and return rows that fall within a range of values.

B.

The table will be scanned over a certain range of values.

C.

This type of index uses the range hash.

D.

There is a range of indexes that can be used.

Question 16

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

Options:

A.

mysqldumpslow

B.

mysqldump

C.

mysqlaccess

D.

mysqlshow

E.

mysqlslow

Question 17

Why should you be selective when granting the PROCESS privilege to an account?

Options:

A.

It allows a client to process scripts.

B.

It allows the use of stored routines.

C.

It allows a client to see another user’s queries with the SHOW PROCESSLIST command.

D.

It allows a client to control running processes on a server.

Question 18

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

Options:

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

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