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

1z0-883 Questions and Answers

Note! Following 1z0-883 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-883 Questions and Answers

Question # 6

Consider the following table:

CREATE TABLE ‘game’ (

‘id’ int (10) unsigned NOT NULL AUTO_INCREMENT,

‘keyword’ varchar (45) DEFAULT NULL,

‘date’ datetime NOT NULL,

PRIMARY KEY (‘id’ , ‘date’),

UNIQUE KEY ‘keyword_idx’ (‘keyword’ , ‘date’)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

PARTITION BY RANGE (TO_DAYS (date) ) (

PARTITION g201301 VALUES LESS THAN (TO_DAYS (‘2013-01-01 00:00:00’) ),

PARTITION g201302 VALUES LESS THAN (TO_DAYS (‘2013-02-01 00:00:00’) ),

PARTITION g201303 VALUES LESS THAN (TO_DAYS (‘2013-03-01 00:00:00’) ),

PARTITION g201304 VALUES LESS THAN (TO_DAYS (‘2013-04-01 00:00:00’) ),

PARTITION gMORES VALUES LESS THAN (MAXVALUE) );

Which method should used to add a new g201305 partition to the table?

A.

ALTER TABLE games

REORGANIZE PARTITION (gMORES)

INTO

g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),

gMORES VALUES LESS THAN (MAXVALUE) );

B.

ALTER TABLE games

ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) );

C.

ALTER TABLE games

COALESCE PARTITION (gMORES)

INTO

g01305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),

gMORES VALUES LESS THAN (MAXVALUE) );

D.

ALTER TABLE games

SPLIT PARTITION (gMORES)

INTO

g201305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),

gMORES VALUES LESS THAN (MAXVALUE) );

E.

ALTHER TABLE games

DROP PATITION gMORES,

ADD PARTITION

g201305 VALUES LESS THAN (TO_DAYS (‘2013-05-01 00:00:00’) ),

gMORES VALUES LESS THAN (MAXVALUE) );

Full Access
Question # 7

A database exists as a read-intensive server that is operating with query_cachek_type = DEMAND.

The database is refreshed periodically, but the resultset size of the queries does not fluctuate.

Note the following details about this environment:

  • A web application uses a limited set of queries.
  • The Query Cache hit rate is high.
  • All resultsets fit into the Query Cache.
  • All queries are configured to use the Query Cache successfully.

The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.

Based solely on the information provided, what is the most likely cause for this slowdown at the database level?

A.

The Query Cache is pruning queries due to an increased number of requests.

B.

Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups.

C.

Mutex contention on the Query Cache is forcing the queries to take longer due to its single-threaded nature.

D.

The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution.

Full Access
Question # 8

Which three tasks can be performed by using the performance Schema?

A.

Finding queries that are not using indexes

B.

Finding rows that are locked by InnoDB

C.

Finding client connection attributes

D.

Finding the part of a code in which a single query is spending time

E.

Finding the size of each table

Full Access
Question # 9

MySQL is installed on a Linux server and has the following configuration:

[mysqld]

User=mysql

Datadir=/data/mysql

As the ‘root’ user, change the datadir location by executing:

Shell> cp –R /var/lib/mysql/data/mysql/

Shell> chown –R mysql /data/mysql/

What is the purpose of changing ownership of datadir to the ‘mysql’ user?

A.

MySQL cannot be run as the root user.

B.

MySQL requires correct file ownership while remaining secure.

C.

MySQL needs to be run as the root user, but file cannot be owned by it.

D.

The mysqld process requires all permissions within datadir to be the same.

Full Access
Question # 10

Which three statements are true about memory buffer allocation by a MySQL Server?

A.

Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B.

Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C.

Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D.

User buffers are allocated at server startup and freed when the user is dropped.

E.

All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

Full Access
Question # 11

You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:

ERROR 2059 (HY000): Authentication plugin ‘mysql_clear_password’ connot be loaded: plugin not enabled

What would you run to fix the issue?

A.

The mysql client with the – ignore-password-hashing option

B.

The mysql_secure_installation script to update server security settings

C.

The mysql client with the – enable-cleartext-plugin option

D.

The mysql_upgrade script

E.

The install plugin command for the mysql_cleartext_password plugin

Full Access
Question # 12

Consider the Mysql Enterprise Audit plugin.

The following event detail is found in the audit log:

TIMESTAMP=”2013-04-09t01:54:17”

NAME=”Connect”

CONNECTION_ID=”3”

STATUS=”1045”

USER=”kate”

PROXY_USER=””

HOST=”localhost”

IP=””

DB=””/>

Which two points can be concluded from the given event?

A.

A connection was blocked by a firewall or a similar security mechanism.

B.

A connection was attempted via socket rather than TCP.

C.

A connection failed because the proxy user privileges did not match the login user.

D.

A connection as the user kate was successful.

E.

A connection failed due to authentication being unsuccessful.

Full Access
Question # 13

Which three are properties of the MyISAM storage engine?

A.

Transaction support

B.

FULLTEXT indexing for text matching

C.

Table and page level locking support

D.

Foreign key support

E.

Geospatial indexing

F.

HASH index support

G.

Table level locking only

Full Access
Question # 14

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be ”rolled forward” to provide all the latest data.

The SHOW SLAVE STATUS indicates the following values:

RELAY_LOG_FILE = hostname-relay-bin.00004

RELAY_LOG_POS = 1383

Which command set would make the slave current?

A.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

B.

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = ‘hostname-relay-bin.00004’ , RELAY_LOG_POS = 1383;

C.

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

D.

STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;

Full Access
Question # 15

Consider the following:

Mysql> EXPLAIN SELECT * FROM City WHERE Name = ‘Jacksonville’ AND CountryCode = ‘USA’ \G

******************************** 1. row ********************************

Id: 1

Select_type: SIMPLE

Table: City

Type: ref

Possible_keys: name_country_index

Key: name_country_index

Ref: const, const

Rows: 1

Extra: Using where

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

A.

It shows the total size of the index row.

B.

It shows how many columns in the index are examined.

C.

It shows the number of characters indexed in the key.

D.

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

Full Access