Online Access Free 1Z1-888 Exam Questions

You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

• A.the length of time before a newly created password expires
• B.the amount of delay after an incorrect password is entered
• C.whether a new password is rejected if it contains a word found in a dictionary file.
• D.whether a new password is rejected if it contains the current user's username.

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

• A.mysqlslow
• B.mysqldump
• C.mysqlshow
• D.mysqldumpslow
• E.mysqlaccess

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

• A.The MySQL server has stopped inserting data to check index consistency.
• B.The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
• C.InnoDB has filled the redo log and now must flush the pages.
• D.InnoDB is doing CRC32 checks over the tablespace data as it grows.
• E.Secondary indexes no longer fit into the buffer pool.

A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)

• A.disabling connections from named pipes or socket files (depending on the operating system of the server)
• B.installing MySQL on the application server, and running the database and application on the same server
• C.enabling and using SSL for connections to the MySQL database
• D.running the server with -skip-networking specified
• E.limiting logins to originate from the application server or the server's subnet
• F.starting the server with -bind-address=0.0.0.0 specified

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

• A.setting the --local-infile=0 option when starting mysqld
• B.executing REVOKE FILE FROM *_*
• C.executing REVOKE FILE ON *_* FROM ` `@'%'
• D.executing REVOKE LOAD FROM *.*
• E.setting the --local-service=0 option when starting mysqld
• F.setting the --open-files-limit=0 option when starting mysqld