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

出題：1

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

A. server_id is not unique.

B. The max_connections variable on the slave needs to be increased.

C. The log_bin variable is set to OFF on the slave.

D. The version of the slave is newer that the version of the master.

E. The shared_memory_base_name variable must match the master.

正解：C 解答を投票する

出題：2

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

A. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@'';

B. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';

C. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

D. mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';

正解：A 解答を投票する

出題：3

A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

B. The sync_relay_log=1000 setting on the slave is too small.

C. sync_binlog=0 and the master server crashed.

D. binlog_format=STATEMENT and a non-deterministic query was executed.

E. binlog_cache_size=1024 is too small and transactions are lost.

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

出題：4

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

出題：5

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

B. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

C. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

D. The statement would fail because you cannot update more than one row at a time when using ?
binlogformat = ROW.

E. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

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

出題：6

Which two statements can be used to adjust the sort_buffer_size variable on a running MySQL server?
(Choose two.)

A. mysql> SET SESSION sort_buffer_size=256000;

B. mysql> SET VARIABLE sort_buffer_size=256000;

C. mysql> system sort_buffer_size=256000;

D. mysql> SET GLOBAL sort_buffer_size=256000;

E. mysql> CONF T; do global sort_buffer_size=256000;

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

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

出題：7

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

A. The stored procedure named get_reports will be dropped.

B. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.

C. The user will get an error because he or she did not put the database name in front of the stored procedure name.

D. The user will get an error because he or she does not have the permission to drop stored procedures.

正解：A 解答を投票する

出題：8

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations. Which two other steps can help avoid data loss in a major catastrophe?

A. Use on-site network-attached storage to separate service from datA.

B. Create a master-master pair for each service.

C. Have a second data centre in a different region or country.

D. Implement a failover strategy to another geographic location.

E. Use RAID 10 storage for datA.

F. Keep software updated to the latest version.

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

出題：9

Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

A. The .mylogin.cnf file is not readable.

B. The mysqld instance has not been restarted after creating the login path.

C. The host on the command line is not defined in the login path.

D. The DNS is not configured correctly for slave1 host.

E. There is no password defined in the login path.

正解：A 解答を投票する

出題：10

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

A. Deactivate the query cache.

B. Increase the value of the innodb_read_io_threads option.

C. Increase the size of the InnoDB buffer pool.

D. Change the table to use HASH indexes instead of BTREE indexes.

E. Increase the value of the innodb_lock_wait_timeout option.

F. Set the value of innodb_adaptive_hash_index to zero.

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

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