← Back to exam page

1z0-882 – MySQL 5.6 Developer

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Using the MYSQL command –line client you have received the error “Lost connection to MYSQL server query”

Which three are possible causes of the error?

Select all that apply, then click Submit answer.

  • ○

    The MYSQL server stopped working during query execution.
  • ○

    The network connection was interrupted during query execution.
  • ○

    The connection that issued the query was killed.
  • ○

    The client connection stayed idle for longer than interactive –timeout seconds and was closed.
  • ○

    The client sent an erroneous query to the server causing the connection to be closed.
  • ○

    The server interrupted client connection after max-connect-errors was achieved.
Question 5

Which two keywords cannot be used in multi-table deletes?

Select all that apply, then click Submit answer.

  • ○

    USING
  • ○

    ORDER BY
  • ○

    LIMIT
  • ○

    IGNORE
  • ○

    JOIN
Question 6

You want to use the SHA -256 Authentication plugin with Connector/J.

Which two parameter settings achieve this?

Select an option, then click Submit answer.

  • ○

    Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc
  • ○

    Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
  • ○

    defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin
  • ○

    defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin