1Z0-888試験無料問題集（155題）「Oracle MySQL 5.7 Database Administrator 認定」

出題：1

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid for why one of the users is unable to connect to the database?

A. All users are blocked because max_user_connections is accumulated over the host account information.

B. Kay is already connected elsewhere and attempting to log in again.

C. Bob has max_user_connections set to zero, which blocks all his connections.

D. Joe has exceeded the max_user_connections global limit.

E. connect_timeout is too small to allow a connection to occur.

正解：D 解答を投票する

出題：2

Consider the ANALYZE TABLE command.
In which two situations should this command be used?

A. when you want to check a tables structure to see if it may have been damaged and needs repair

B. when you want to update index distribution statistics

C. when you need to find out why a query is taking a long time to execute

D. after large amounts of table data have changed

正解：B,D 解答を投票する

出題：3

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

B. The sync_relay_log=1000 setting on the slave is too small.

C. sync_binlog=0 and the master server crashed.

D. binlog_format=STATEMENT and a non-deterministic query was executed.

E. binlog_cache_size=1024 is too small and transactions are lost.

正解：A,E 解答を投票する

出題：4

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

A. Date should be a TIMESTAMP field for better performance.

B. No indexes are defined.

C. The engine type is not appropriate to the application use.

D. The User field is too long for most names.

E. Using default values for DATETIME causes table scans.

正解：B,C 解答を投票する

出題：5

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

B. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

C. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

D. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

正解：D 解答を投票する

出題：6

You have set innodb_stats_auto_recalc to OFF.
For tables using persistent statistics, what is the outcome of this change?

A. InnoDB no longer automatically updates index statistics after 10% of the rows in a table change.

B. InnoDB no longer automatically updates index statistics after the table structure is altered.

C. InnoDB no longer automatically updates index statistics after an ANALYZE TABLE statement.

D. InnoDB no longer automatically updates index statistics after a CREATE TABLE statement.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

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

A. monitoring the innodb_redo_log_size variable

B. monitoring cumulative Innodb_page_size increase

C. monitoring the performance_schema_hosts_size variable

D. monitoring the Innodb_rows_inserted status variable

E. monitoring datadir size in the operating system

F. monitoring the information_schemA.TABLES table

正解：E,F 解答を投票する

出題：8

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

正解：A,C 解答を投票する

出題：9

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

A. Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:

B. Take a backup, stop the server, remove the data files, and restore the backup:

C. Execute OPTIMIZE TABLEso that the InnoDB engine frees unused pages on disk back to the file system:

D. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:

正解：D 解答を投票する

出題：10

You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

A. -reset-grant-tables, to start the server with only the mysql database accessible.

B. -read-only, to set all data to read-only except for super users

C. -skip-networking, to prohibit access from remote locations

D. -old-passwords, to start MySQL to use the old password format while running without the grant tables.

正解：C 解答を投票する

1Z0-888試験無料問題集「Oracle MySQL 5.7 Database Administrator 認定」