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

出題：1

Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?

A. service mysqld stop

B. mysqld -e 'shutdown'

C. mysqladmin shutdown

D. mysql -e 'shutdown'

正解：B 解答を投票する

出題：2

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

A. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'

B. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com

C. SET GLOBAL mysql_cleartext_passwords=1;

D. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com

E. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';

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

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

出題：3

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

出題：4

Which two statements are true about InnoDB auto-increment locking?

A. InnoDB does not use locks to enforce auto-increment uniqueness.

B. InnoDB always protects auto-increment updates with a table-level lock

C. InnoDB never uses table_level locks.

D. Some settings for innodb_autoinc_lock_mode can help reduce locking.

E. The auto-increment lock can be a table-level lock.

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

出題：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

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

A. Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

B. Check the difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

C. Check the difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"

D. Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

E. Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

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

出題：7

At which stage during query processing does MySQL create a query's execution plan?

A. Executing

B. Parsing

C. Optimizing

D. Authorizing

正解：C 解答を投票する

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

出題：8

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

出題：9

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

出題：10

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

A. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.

B. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.

C. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

D. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.

正解：D 解答を投票する

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