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

出題：1

Examine the mysqldumpslow output:

Which two options could explain the slow query?

A. No index has been defined on the filtered column.

B. There is network congestion between client and server.

C. There are 108 queries still being executed.

D. A table lock is causing delays.

E. A full table scan is being used.

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

出題：2

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

出題：3

What are three typical causes of MySQL becoming suddenly slow and unavailable? (Choose three.)

A. The application executes a new untested query.

B. Monitoring has not enabled all Performance Schema instruments.

C. The MySQL Query Cache is disabled.

D. OPTIMIZE TABLE is not executed for the InnoDB tables.

E. A configuration change was made.

F. The hardware includes a single point of failure.

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

出題：4

Consider:

Which statement best describes the meaning of the values in the ref columns?

A. world.City.CountryCode is used to sort the rows in the Citytable.

B. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.

C. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

D. world.City.CountryCodeis used as the primary key for the Country table.

正解：C 解答を投票する

出題：5

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?

A. Use mysql_install_db.

B. Pass --log-error=/var/lib/mysql_QA/mysqld.log.

C. Change permissions on /var/log/mysqld.log to allow writes.

D. Use --no-defaults to ignore the existing config file in the default PATH.

正解：A 解答を投票する

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

出題：6

What does the Performance Schema provide?

A. recommendations for schema changes

B. auto-tuning based on settings and ongoing workload

C. insight into the internal working of MySQL

D. a text-based version of MySQL Enterprise Monitor

正解：C 解答を投票する

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

出題：7

To query two system variables, you execute this statement and get the results shown:

When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?

A. max_connections must be set at server start in an options file.

B. max_connections must be set globally instead of locally.

C. max_connections is a read-only variable that cannot be set dynamically.

D. max_connections is a derived variable that can only be set indirectly.

正解：A 解答を投票する

出題：8

What three are correct statements about MySQL backups? (Choose three.)

A. They are used to set up a test system.

B. They are used to set up a replication slave.

C. They are used to prevent data theft.

D. They are used to recover data.

E. They are used to prevent data corruption.

F. They are used to set up the initial binary log files.

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

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

出題：9

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

A. setting --mysql_secure_configuration to enable paranoid mode

B. setting specific grant privileges to limit remote authentication

C. using SSL when transporting data over remote networks

D. setting --skip-networking when remote connections are not required

E. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

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

出題：10

Which three options are most likely to be changed for production form their default values?

A. max_connections

B. innodb_buffer_pool_size

C. max_user_connections

D. join_buffer_size

E. character_set_system

F. port

G. innodb_log_file_size

正解：B,F,G 解答を投票する

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