mysql ocp真题

Certkiller.1z0-883 questions

BY:Furple 20161201

QUESTION 1

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.

$ pidof mysqld

$tail - n2 /var/lib.mysql/hostname.err

2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld: ready for connections.

Version: `5.6.13-enterprise-commercial-advaced' socket: `/tmp/mysql.sock' port;

3306 Mysql Enterprise Server Advanced Edition (Commercial)

You attempt to log in as the root user with the following command:

$mysql u root

ERROR 1045 (28000): Access denied for user `root'@'localhost' (using password: NO)

1

Which statement is true about this scenario?

QUESTION 3

A Mysql Server has been running an existing application successfully for six months.

The my.cnf is adjusted to contain the following additional configuration:

[mysqld]

Default-authentication-plugin=sha256_password

The Mysql Server is restarted without error.

What effect will the new configuration have in existing accounts?

A. They will have their passwords updated on start-up to sha256_password format.

B. They will have to change their password the next time they login to the server.

C. They are not affected by this configuration change.

In a design situation, there are multiple character sets that can properly encode your data.

Which three should influence your choice of character set?

2

A. Disk usage when storing data

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

3

A. Mysql Replication

B. Distributed Replicated Block Device (DRBD) and Mysql

C. Windows Cluster and Mysql

D. Solaris Cluster and Mysql

E. Mysql NDB Cluster

Correct Answer: ABE

QUESTION 7

Which three statements are characteristic of the MEMORY storage engine?

A. Each table is represented on disk as an.frm file.

B. Each table has a corresponding.MYI and .MYD file.

C. It can support foreign keys.

4

D. It cannot contain text or BLOB columns.

The following event detail is found in the audit log:

<AUDIT_RECORD

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

NAME="Connect"

CONNECTION_ID="3"

STATUS="1045"

USER="kate"

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.

5