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

Note! 1z0-883 has been withdrawn.

Practice Free 1z0-883 MySQL 5.6 Database Administrator Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the Oracle 1z0-883 Exam the most current and reliable questions . To help people study, we've made some of our MySQL 5.6 Database Administrator exam materials available for free to everyone. You can take the Free 1z0-883 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 100 Questions Search Other Oracle Exam
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.

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

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)

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

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

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.

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.

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.

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.

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.