1z1-908試験無料問題集（142題）「Oracle MySQL 8.0 Database Administrator 認定」

出題：1

Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is an intentional lock.

B. The lock is at the metadata object level.

C. The lock is a shared lock.

D. The lock is an exclusive lock.

E. The lock is a row-level lock.

F. The lock is at the table object level.

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

出題：2

You wish to store the username and password for a client connection to MySQL server in a file on a local file system.
Which is the best way to encrypt the file?

A. Use mysql_secure_installation to encrypt stored login credentials.

B. Use mysql_config_editor to create an encrypted file.

C. Use the AES_ENCRYPT() MySQL function on the option file.

D. Use a text editor to create a new defaults file and encrypt it from Linux prompt.

正解：B 解答を投票する

出題：3

Which three actions are effective in capacity planning? (Choose three.)

A. monitoring OS resources for patterns

B. upgrading to the latest application version

C. basing expected growth on an average of the last 3 years

D. adding circular replication nodes for increased DML capability

E. consulting the application team about any future projects and use

F. buying more CPU

G. buying more disk

H. buying more RAM

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

出題：4

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?

A. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.

B. Look for queries with low total latency times in the Latency section in the times series graph.

C. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

正解：A 解答を投票する

出題：5

Examine this query and its output:

Which two statements are true? (Choose two.)

A. The root user had the largest number of modified rows for a SELECT statement.

B. User bob had the largest total time waiting for locks.

C. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

D. The app user had the highest total number of rows read from storage engines.

E. The root user had the largest single wait time.

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

出題：6

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

A. Decrease the number of buffer pool instances to 1.

B. Increase the number of buffer pool instances to 12.

C. Decrease the number of buffer pool instances to 4.

D. Increase the number of buffer pool instances to 32.

E. Increase the number of buffer pool instances to 16.

正解：D 解答を投票する

出題：7

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The redo logs are not backed up at all.

B. The redo logs are backed up only if there are changes showing for the transactions tables.

C. The redo logs are backed up first, then the transaction and archive tables.

D. The archive tables are backed up first, then the transaction tables and redo logs.

E. The transaction tables are backed up first, then the archive tables and redo logs.

正解：B 解答を投票する

出題：8

Which three requirements must be enabled for group replication? (Choose three.)

A. replication filters

B. slave updates logging

C. primary key or primary key equivalent on every table

D. binary log MIXED format

E. binary log checksum

F. binary log ROW format

G. semi-sync replication plugin

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

出題：9

Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

A. PIPE

B. TCP

C. FILE

D. IPv6

E. MEMORY

F. DIRECT

G. SOCKET

H. IPv4

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

出題：10

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

A. TCP/IP

B. named pipes

C. SOCKET

D. UDP

E. shared memory

F. X Protocol

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

1z1-908試験無料問題集「Oracle MySQL 8.0 Database Administrator 認定」