MySql 1z0-883

Certkiller.1z0-883.108 questions

Number: 1z0-883

Passing Score: 800

Time Limit: 120 min

File Version: 5.4

http://www.gratisexam.com/

exam!

I finally got the biggest success in the admission test and that happened due to the greatest and superb website.

Smart work always better than the hard work and Test King provides you the smart ways to get succeeded through its tools.

Exam A

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.

C. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.

QUESTION 2

You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands:

$ 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)

D. The mysql_install_bd post-installation script used random-password.

Correct Answer: B

Section: (none)

Explanation

Explanation/Reference:

Explanation:

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]

D. They all connect via the secure sha256_password algorithm without any configuration change.

Correct Answer: D

Section: (none)

Explanation

Explanation/Reference:

Reference: http://dev.mysql.com/doc/refman/5.6/en/sha256-authentication-plugin.html

QUESTION 4

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

D. Memory usage when working with the data

E. Character set mapping index hash size

Correct Answer: CDE

Section: (none)

Explanation

Explanation/Reference:

genuine answer.

QUESTION 5

What are three actions performed by the mysql_secure_installation tool?

A. It prompts you to set the root user account password.

Explanation

Explanation/Reference:

Reference: http://prefetch.net/blog/index.php/2006/06/18/securing-mysql-installations-with- mysql_secure_installation/