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

出題：1

On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A. Use the limit clause in conjunction with the order 3Y clause.

B. Use the limit clause to limit the deletion to 100.000 rows.

C. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.

D. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.

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

出題：2

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 メンバーにのみ表示されます)

出題：3

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A. Invoke mysql with the --initialize option.

B. Run the create_system_tables.sql file

C. Run the mysql_unpack.sql file

D. Invoke mysqld with the --initialize option.

正解：D 解答を投票する

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

出題：4

You want to dump only data from the userdata table.
Which mysqldump command argument is required to accomplish this?

A. --data-only as this specifies that only data is to be dumped

B. --table=userdata in order to dump only the data from the userdata table

C. --no-create-info to skip writing CREATE TABLE statements

D. --single-transaction as this obtains a consistent view of data only

正解：D 解答を投票する

出題：5

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

出題：6

The MySQL instance is a default RPM installation on a Linux server.
Where are the errors written?

A. in the /var/log/mysqld.err file

B. in the /var/lib/mysql/hostname.log file

C. no logging enabled by default

D. in the syslog daemon on the server

正解：A 解答を投票する

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

出題：7

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

出題：8

Which two are considered good security practices when using passwords? (Choose two.)

A. Do not use dictionary-based words.

B. Use simple keyboard actions that give mixed letters.

C. Use one-way encryption for storage of passwords.

D. Store passwords external to the database.

E. Choose short passwords to save on storage space.

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

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

出題：9

You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?

A. the number of times the statement was executed

B. the name of the user issuing the statement

C. an abbreviation for NULL in a statement

D. an abstracted substitution for numbers indicated in WHERE clauses

正解：A 解答を投票する

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

出題：10

Which two statements describe how InnoDB recovery works?

A. There will in general be lost committed transactions after a crash using the default settings.

B. It is recommended to set innodb_force_recovery = 1 as part of normal operations.

C. InnoDB handles most crash recoveries automatically.

D. It is always required to enable innodb_force_recovery to perform a crash recovery.

E. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.

F. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.

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

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