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

出題：1

Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

A. to make sure a table has no structural problems

B. to find out why a query takes a long time to execute on a given table

C. to make sure that no table indexes are corrupted

D. to improve performance by updating index distributing statistics on InnoDB tables

E. to repair table structure problem

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

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

出題：2

What are two benefits of using the --tab option with mysqldump? (Choose two.)

A. It can be piped directly into a running server.

B. It is possible to restore the data in parallel.

C. It can be used together with --all-databases.

D. The schema and data are automatically dumped to separate files.

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

出題：3

Examine the mydata table and SELECT statements:

You issue:
mysql> begin;
mysql> update mydata set a=0 where b=3;
How many rows are now protected by locks with the default InnoDB configuration?

A. one row and a next-key lock for supremum

B. five

C. one row and a gap-lock

D. one

正解：B 解答を投票する

出題：4

Which two capabilities are granted with the SUPER privilege? (Choose two.)

A. allowing client accounts to take over the account of another user

B. allowing a client to kill other client connections

C. allowing change of the server runtime configuration

D. allowing a client to shut down the server

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

出題：5

Which statement best describes the purpose of the InnoDB buffer pool?

A. It caches data and indexes for InnoDB tables.

B. It caches only the indexes for InnoDB tables.

C. It holds changes made during a transaction before they are written to the log.

D. It is amount of buffers available during a transaction.

E. It is a pool of memory for SQL query sort operations from within the InnoDB engine.

正解：A 解答を投票する

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

出題：6

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 解答を投票する

出題：7

You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

A. InnoDB has filled the redo log and now must flush the pages.

B. InnoDB is doing CRC32 checks over the tablespace data as it grows.

C. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.

D. Secondary indexes no longer fit into the buffer pool.

E. The MySQL server has stopped inserting data to check index consistency.

正解：E 解答を投票する

出題：8

Consider:

What does the range value in the type column mean?

A. There is a range of indexes that can be used.

B. The table will be scanned over a certain range of values.

C. This type of index uses the range hash.

D. You can use an index and return rows that fall within a range of values.

正解：C 解答を投票する

出題：9

You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

A. ALTER USER bob@'%' IDENTIFIED BY `secret_password';

B. ALTER USER bob PASSWORD = `secret_password';

C. ALTER USER `'@'localhost' PASSWORD = `secret_password';

D. ALTER USER `root'@'localhost' ACCOUNT LOCK;

E. REVOKE ALL PRIVILEGES FROM `'@'localhost';

F. DROP USER `'@'localhost';

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

出題：10

Which two statements are true regarding MySQL security? (Choose two.)

A. The root or administrator users should own all files and directories to which the server writes.

B. The mysqld process owner should own all files and directories to which the server writes.

C. The mysqld process should not be run as root or administrator.

D. The mysqld process should be run as root or administrator.

E. The mysql user needs to have sudo privileges.

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

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