1Z1-888 試験問題を無料オンラインアクセス

Which two options describe how MySQL Server allocates memory?

• A.Global memory resources are allocated at server startup.
• B.Thread memory is pre-allocated up to thread_cache_size for performance.
• C.Each thread allocates memory from a global pool.
• D.Each connection may have its own per-thread memory allocations.

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A.They will have their passwords updated on start-up to sha256_password format.
• B.They will have to change their password the next time they login to the server.
• C.They all connect via the secure sha256_password algorithm without any configuration change.
• D.They are not affected by this configuration change.

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?

• A.This prevents mysqld from starting when standard startup scripts are used.
• B.The mysql user needs a login and its home directory must be the base directory of the installation.
• C.This prevents creation of a command shell with the mysql account, while allowing mysqld to run.
• D.The OS needs to allow logging in as mysql so that administrative tasks can be performed.

Which two methods accurately monitor the size of your total database size over time?

• A.monitoring the information_schemA.TABLES table
• B.monitoring cumulative Innodb_page_size increase
• C.monitoring the Innodb_rows_inserted status variable
• D.monitoring the performance_schema_hosts_size variable
• E.monitoring the innodb_redo_log_size variable
• F.monitoring datadir size in the operating system

Which statement best describes a "warm" backup?

• A.It is similar to a "hot" backup, but differs in that it does not permit write operations.
• B.It is similar to a "cold" backup, but differs in that it permits write operations.
• C.It only backs up "warm" data, that is, data that has been recently modified.
• D.It backs up the binary log, which contains the most recent "warm" changes.