Online Access Free 1z0-883 Practice Test

Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data:
'GREEN01020495888331993-12-10/2...'
What should you do to improve the overall performance?

• A.Convert their column to BINARY.
• B.Convert the column to TEXT and add a fulltext index to the table.
• C.Create multiple prefix indexes of differing lengths.
• D.Redesign the table so that the most commonly searched for string patterns are in their own columns.

Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?

• A.3; only the top-level statements are logged.
• B.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.
• C.111; top-level statements and all lower-level statements are logged.
• D.12; only top-level statements and stored procedure events are logged.

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?

• A.There is no dictionary file defined, so password validation cannot work as expected.
• B.The password does not match the validate_passoword_number_count requirement.
• C.The password is eight characters long, but needs to exceed validate_password_length to be valid.
• D.The password matches a substring Hover as a dictionary word.
• E.All of the MEDIUM password policy requirements have not been honored.

Which hardware storage option, when set up with redundant disks, offers the least stability, availability, and reliability for Mysql data?

• A.SAN (Storage Area Network)
• B.NFS (Networked File System)
• C.iSCSI
• D.RAID 5

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

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