← Back to exam page

1z0-883 – MySQL 5.6 Database Administrator

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which two capabilities are granted with the SUPER privilege?

Select all that apply, then click Submit answer.

  • ○

    Allowing a client to kill other client connections
  • ○

    Allowing a client to shut down the server
  • ○

    Allowing change of the server runtime configuration
  • ○

    Allowing client accounts to take over the account of another user
Question 2

Which three statements describe how the strict SQL mode provides added security?

Select all that apply, then click Submit answer.

  • ○

    It rejects statements that try to insert out-of-range values
  • ○

    It rejects invalid dates.
  • ○

    It limits the operations that the server can perform.
  • ○

    It rejects queries that produce out-of-range values.
  • ○

    It rejects dates with zero day or month values.
Question 3

Which two statements are true regarding partitioning in Mysql?

Select all that apply, then click Submit answer.

  • ○

    Tables with BLOB and TEXT columns cannot be partitioned.
  • ○

    Partitioning allows easier management of smaller data sets for certain queries.
  • ○

    Partitioning allows different columns to be stored in separate files.
  • ○

    The partitioning expression is an integer or function that returns an integer value or NULL value.
  • ○

    Partitioning is only available for those storage engines that implements it natively.