New Year Special - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! 1z0-883 has been withdrawn.

1z0-883 Practice Exam Questions with Answers MySQL 5.6 Database Administrator Certification

Question # 6

A general purpose MySQL instance is configured with the following options:

-- log-slow-queries

-- long-query-time=,0001

-- log-slow-admin-queries

-- general-log

-- log-bin

-- binlog-format=STATEMENT

-- innodb-flush-log-at-trx-commit=1

Which three statements are true?

A.

The General Query Log records more data than the Binary Log.

B.

The binary Log records more data than the General Query Log.

C.

The Slow Query Log records more data than the General Query Log.

D.

The General Query Log records more data than the Slow Query Log.

E.

The Slow Query Log records more data than the Binary Log.

F.

The Binary Log records more data than the Slow Query Log.

Full Access
Question # 7

Which two requirements would lead towards a high availability solution?

A.

When uptime is critical

B.

When data must be refactored

C.

When application concurrency is static

D.

When data loss is unacceptable

E.

When application is a single point of failure

Full Access
Question # 8

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

A.

RAID 5

B.

iSCSI

C.

SAN (Storage Area Network)

D.

NFS (Networked File System)

Full Access
Question # 9

Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.

This requires the following config file options:

Sync_binlog=1

Innodb_flush_log_at_trx_commit=1

Innodb_doublewrite=1

However, this configuration is expected to introduce disk I/O overhead.

What three changes will reduce disk I/O overheads?

A.

Use of soft links for database directories on the same physical disk

B.

Use of separate directories on the same physical disk for log files and data files

C.

Placement of InnoDB log files and datadir on separate physical disks

D.

Allocation of RAM to the buffer pool such that more of the data can fit in RAM

E.

Use of delay_key_write=ON for batch index update

Full Access
Question # 10

Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?

A.

Mysqlslow

B.

Mysqldumpslow

C.

Mysqlshow

D.

Mysqldump

E.

Mysqlaccess

Full Access
Question # 11

Consider the following statement on a RANGE partitioned table:

ALTER TABLE orders DROP PARTITION p1, p3;

What is the outcome of executing the above statement?

A.

Only the first partition (p1) will be dropped as only one can be dropped at any time.

B.

All data in p1 and p3 partitions are removed, but the table definition remains unchanged.

C.

A syntax error will result as you cannot specify more than one partition in the same statement.

D.

All data in pi and p3 partitions are removed and the table definition is changed.

Full Access
Question # 12

Which two are true regarding MySQL binary and text backups?

A.

Binary backups are usually faster than text backups.

B.

Binary backups are usually slower than text backups.

C.

Text backups are human-readable while binary backups are not.

D.

Binary backups are not portable across different operating systems.

Full Access
Question # 13

The following commands are available in the Linux binary distributions of Mysql:

  • Mysqld
  • Mysqld_safe
  • Mysql.server

What is the correct description of each of these commands?

A.

Mysqld is the server.

Mysqld_safe is a shell script that invokes mysqld.

Mysql.server is a wrapper for mysql_safe.

B.

Mysqld is a shell script that starts mysql.server.

Mysqld_safe causes the server to start up in data recovery mode.

Mysql.server is the server.

C.

Mysqld is the server.

Mysqld_safe causes the server to start up in data recovery mode.

Mysql.server is a wrapper for mysqld_safe.

D.

Mysql, mysqld.safe, and mysql.server reside in different locations but are all symlinked to the same script.

Full Access
Question # 14

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

Mysql> SHOW GLOBAL VARIABLES LIKE ‘%connect%’;

1z0-883 question answer

8 rows in set (0.00 sec)

A look at the user privileges shows:

GRANT… TO ‘bob’@’%, example.com’ WITH MAX_USER_CONNECTIONS 0;

GRANT… TO ‘key’@’%, example.com’ WITH MAX_USER_CONNECTIONS 1;

GRANT… TO ‘joe’@’%, example.com’ WITH MAX_USER_CONNECTIONS 50;

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

A.

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

B.

Joe has exceeded the max_user_connections global limit.

C.

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

D.

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

E.

Connect_timeout is too small to allow a connection to occur.

Full Access
Question # 15

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

A.

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

B.

It is shared-nothing architecture.

C.

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

D.

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

Full Access