← Back to exam page

1z0-883 – MySQL 5.6 Database Administrator

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Identify a performance impact when using the Performance Schema.

Select an option, then click Submit answer.

  • ○

    There is no impact on performance.
  • ○

    There is an overhead for querying the Performance Schema but not for having it enabled.
  • ○

    There is a constant overhead regardless of settings and workload.
  • ○

    The overhead depends on the settings of the Performance Schema.
Question 8

You have a server that has very limited memory but has a very large table.

You will use mysqldump to back up this table.

Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

Select an option, then click Submit answer.

  • ○

    -- quick
  • ○

    -- skip-buffer
  • ○

    -- single-transaction
  • ○

    -- tab
Question 9

You adjust a default configuration to the following /etc/my.cnf on a Linux installation:

[mysqld]

Loq-bin

Binrylog_format=ROW

You do not notice the spelling error in binrylog_format and restart your production server.

How does the MySQL server behave with incorrectly spelled options?

Select an option, then click Submit answer.

  • ○

    Mysqld uses internal configuration versioning and reverts to the previous configuration.
  • ○

    When using mysql_config_editor for configuration adjustments, it detects incorrect syntax and typing mistakes.
  • ○

    The mysqld_safe script skips the unknown variable and starts using the remaining configuration changes.
  • ○

    Mysqld prints to the error log about an unknown variable, and then exits.