Online Access Free 1Z0-888 Exam Questions

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

• A.mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';
• B.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
  `employee'@'localhost' TO ''@'';
• C.mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';
• D.mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?

• A.The access does not take effect until you issue the FLUSH PRIVILEGES statement.
• B.The access does not take effect until the user logs out and back in.
• C.The access is available immediately.
• D.The access does not take effect until the next time the server is started.

You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:

Which statement is true about the output?

• A.The event with event_id = 8945 is a child of the event with event_id=8944.
• B.The time the query took is the sum of all timer_wait values.
• C.The query did not find its table in the table definition cache.
• D.The query read data from the data file rather than directly from the buffer pool.

You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?

• A.Start the MySQL Server with --initialize-insecure to force a password reset procedure on the command line.
• B.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
• C.Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
• D.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
• E.Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

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.running the server with -skip-networking specified
• C.enabling and using SSL for connections to the MySQL database
• D.limiting logins to originate from the application server or the server's subnet
• E.starting the server with -bind-address=0.0.0.0 specified
• F.installing MySQL on the application server, and running the database and application on the same server