Free 1Z0-883 Exam Dumps PDF Preview

Question 1

Multiple choice

Assume that you want to know which Mysql Server options were set to custom values.

Which two methods would you use to find out?

A
Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
B
Check the command-line options provided for the Mysql Server and compare them with default values.
C
Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
D
Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

Reveal answer details Close answer details

Correct answersC, D

Question 2

Single choice

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

Reveal answer details Close answer details

Correct answerB

Question 3

Single choice

Which query would you use to find connections that are in the same state for longer than 180 seconds?

A
SHOW FULL PROCESSLIST WHEER Time > 180;
B
SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ),
INTERVAL 180 SECOND) );
C
SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB
(NOW ( ), INTERVAL 180 SECOND) );
D
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;

Reveal answer details Close answer details

Correct answerA

Question 4

Multiple choice

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

A
Mysql Enterprise Backup
B
Mysqldump with binary-data option
C
Mysqlhotcopy
D
File system snapshots
E
Mysqldumpslow

Reveal answer details Close answer details

Correct answersA, B

Question 5

Single choice

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.

Reveal answer details Close answer details

Correct answerB

Question 6

Single choice

Consider the query:
Mysql> SET @run = 15;
Mysql> EXPLAIN SELECT objective, stage, COUNT (stage) FROM iteminformation
WHERE run=@run AND objective='7.1' GROUP BY objective,stage
ORDER BY stage;

The iteminformation table has the following indexes;

Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.

What is the primary improvement that can be made for this scenario?

A
Execute the run_2 index because it has caused a conflict in the choice of key for this query.
B
Drop the run_2 index because it has caused a conflict in the choice of key for this query.
C
Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.
D
Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.
E
Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

Reveal answer details Close answer details

Correct answerB

Question 7

Single choice

Consider the MySQL Enterprise Audit plugin.

On attempting to start the MySQL service after a crash, notice the following error:

[ERROR] Plugin `audit_log' init function returned error.

In the audit log file, you notice the final entry:
...
<AUDIT_RECORD
TIMESTAMP="2013-07-09T02:12:35"
NAME="Connect"
CONNECTION_ID="98"
STATUS="0"
USER="Kate"
PRIV_USER="kate"
OS_LOGIN=""
HOST="localhost"
DB=""/>

What action should you take to fix the error and allow the service to start?

A
Re-install the audit plugin.
B
Execute the command FLUSH LOGS.
C
Execute the command SET GLOBAL audit_log_fiush= ON.
D
Move or rename the existing audit.log file.

Reveal answer details Close answer details

Correct answerB

Question 8

Multiple choice

Which two are correct steps in taking a binary backup of MyISAM tables?

A
Always stop the server prior to the backup.
B
Stop the server or lock the tables prior to the backup.
C
Stop the server or lock the databases prior to the backup.
D
Make a copy of the .frm, .myd, and the .myi files.
E
Make a copy of the binary log and tablespace files.

Reveal answer details Close answer details

Correct answersB, D

Question 9

Multiple choice

What are three methods to reduce Mysql server exposure to remote connections?

A
Setting -- skip-networking when remote connections are not required
B
Using the sql_mode=STRICT_SECURE after connections are established for encrypted
communications
C
Setting specific GRANT privilege to limit remote authentication
D
Setting mysql_secure_configuration to enable paranoid mode
E
Using SSL when transporting data over remote networks

Reveal answer details Close answer details

Correct answersB, C, D

Question 10

Single choice

ROW-based replication has stopped working. You investigate the error log file and find the following entries:

2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;
Can't find record in `t1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master
log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032
2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in `t1' Error_code: 1032 2013-08-27 14:15:47
9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL
thread with "SLAVE START". We stopped at log `56_master- bin.

000003' position 684 Why did you receive this error?

A
The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s
B
The table definition on the slave -litters from the master.
C
Multi-threaded replication slaves can have temporary errors occurring for cross database updates.
D
The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist.

Reveal answer details Close answer details

Correct answerD

Question 11

Single choice

You are having problems with connections from a specific host (192.168.1.15) not closing down correctly.
You want to find the state of the threads from that host check for long-running queries.

Which statement will accomplish this?

A
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST='192.168.1.15';
B
SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';
C
SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';
D
SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

Reveal answer details Close answer details

Correct answerC

Question 12

Single choice

Which statement is true about FLUSH LOGS command?

A
It requires the RELOAD, FILE, and DROP privileges.
B
It closes and reopens all log files.
C
It closes and sends binary log files to slave servers.
D
It flushes dirty pages in the buffer pool to the REDO logs.

Reveal answer details Close answer details

Correct answerB

Question 13

Multiple choice

Mysqldump was used to create a single schema backup; Shell> mysqldump u root p sakila >
sakila2013.sql

Which two commands will restore the sakila database without interfering with other running database?

A
Mysql> USE sakila; LOAD DATA INFILE `sakila2013.sql';
B
Shell> mysql u root p sakila sakila2013.sql
C
Shell> mysql import u root p sakila sakila2013.sql
D
Shell> mysql u root -p e `use sakila; source sakila2013.sql'
E
Shell> mysql u root p silent < sakila2013.sql

Reveal answer details Close answer details

Correct answersB, C

Question 14

Multiple choice

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.

Reveal answer details Close answer details

Correct answersA, D, E

Question 15

Single choice

Consider the following table:

REATE 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) );

Reveal answer details Close answer details

Correct answerB

VOL	TYPE	QUESTIONS
1	Single choice	9
2	Multiple choice	6

Free 1Z0-883 Exam Dumps Preview

MySQL 5.6 Database Administrator

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

QUESTION 13

QUESTION 14

QUESTION 15