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

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

1z0-883 Exam Dumps - MySQL 5.6 Database Administrator

Go to page:
Question # 4

You are attempting to secure a MySQL server by using SSL encryption.

On starting MySQL, you get this error:

130123 10:38:02 [ERROR] mysqld: unknown option ‘—ssl’

What is the cause of the error?

A.

The --- ssl level was not specified.

B.

The server was not started with the – enable--ssl-plugin option.

C.

-- ssl is not a valid server option.

D.

The mysqld binary was not compiled with SSL support.

E.

The server’s SSL certificate was invalid.

Full Access
Question # 5

Which two statements describe the behavior of the server’s SQL mode?

A.

The server’s SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.

B.

The server’s SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

C.

The server’s SQL mode can be changed at the session level with a SET SESSION sql_mode=”new_value” command.

D.

The server’s SQL mode, when globally set on a slave server, applies to events sent from the master.

Full Access
Question # 6

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.

Full Access
Question # 7

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.

Full Access
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)

Full Access
Go to page: