最新的Oracle 1Z0-908免費考試真題

問題1

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A. cluster.addInstance()

B. cluster.forceQuorumUsingPartitionOf()

C. dba.createCluster()

D. dba.checkInstanceConfiguration()

E. dba.configureInstance()

F. cluster.setPrimaryInstance()

G. dba.configureLocalInstance()

正確答案: B,F

問題2

Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

A. It is possible to export statements included in a graph selection in CSV format.

B. It is possible to filter a Query Analyzer view graph by database and by table.

C. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

D. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

正確答案: A

問題3

Which two statements are true about raw binary backups? (Choose two.)

A. The data format is identical to how MySQL stores the data on disk.

B. They are faster than logical backups because the process is a simple file or file system copy.

C. The resulting files are easily human readable.

D. They are required to obtain FIPS security compliance.

E. They are converted to a highly compressible binary format.

正確答案: A,C

問題4

Your my.cnf file contains these settings:

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.
Which contains all the settings that you need to add to or modify the slow log configuration?

A. long_query_time=5
min_examined_row_limit=5000

B. log_throttle_queries_not_using_indexes=5
min_examined_ row_limit=5000

C. log_throttle_queries_not_using_indexes=5

D. min_examined_row_limit=5000

E. long_query_time=5
log_throttle_queries_not_using_indexes=5

F. long_query_time=5
log_throttle_queries_not_using_indexes=5
min_examined_row_limit=5000

G. long_query_time=5

正確答案: B

問題5

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your installation.
Examine the output:

What statement is true about the start attempt?

A. systemd found the mysqld service disabled and failed to start it.

B. MySQL server was not started due to a problem while executing process 2732.

C. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

D. systemd waited for 30 seconds before timing out and start up failed.

E. MySQL server continued to start up even though another process existed.

正確答案: C

問題6

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. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.

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

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

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

正確答案: C

問題7

Which two statements are true about MySQL server multi-source replication? (Choose two.)

A. It needs to be re-instanced after a crash to maintain consistency.

B. It must use GTID replication.

C. It is not compatible with auto-positioning.

D. It does not attempt to detect or resolve replication conflicts.

E. It relies on relay_log_recovery for resilient operations.

F. It uses only time-based replication conflict resolution.

正確答案: B,F

最新的Oracle MySQL 8.0 Database Administrator - 1Z0-908免費考試真題

聯系我們

站內鏈接

最新更新