Newly Released Oracle 1z0-883 Exam PDF

MySQL 5.6 Database Administrator Questions and Answers

Question 13

The validate_password plugin is loaded and displays the following settings in global variables:

Mysql> SHOW VARIABLES LIKE ‘validate_password%’;

When attempting to set your password, you get the following error:

Mysql> SET PASSWORD = PASSWORD (‘Hoverl@%’);

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

What is the cause of the error?

Options:

The password is eight characters long, but needs to exceed validate_password_length to be valid.

All of the MEDIUM password policy requirements have not been honored.

The password matches a substring Hover as a dictionary word.

The password does not match the validate_passoword_number_count requirement.

There is no dictionary file defined, so password validation cannot work as expected.

Question 14

Consider the events_% tables in performance Schema.

Which two methods will clear or reset the collected events in the tables?

Options:

Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;

Using the statement RESET PERFORMANCE CACHE;

Using the statement FLUSH PERFORMANCE CACHE;

Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;

Disabling and re-enabling all instruments

Restarting Mysql

Question 15

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?

Options:

Execute the run_2 index because it has caused a conflict in the choice of key for this query.

Drop the run_2 index because it has caused a conflict in the choice of key for this query.

Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.

Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.

Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

MySQL 5.6 Database Administrator Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce