다운로드 MYSQL : 1Z0-874 질문 & 답 PDF & Test Software

결제와 동시에 학습을 시작할 수 있다면 준비 기간을 하루라도 아낄 수 있습니다. PassTIP의 1Z0-874 자료는 결제 후 1분 이내에 이메일로 전달되며 140문항 전체를 바로 이용하실 수 있습니다.

MYSQL 1Z0-874 시험 개요:

MYSQL 1Z0-874 시험 요강 주제:

MYSQL 1Z0-874 시험 Q&A 한눈에 보기

최신 MYSQL-Certifications 1Z0-874 무료샘플문제

문제 #1

Which of the following are general features of replication? (Choose three)

A. Can be used to distribute the load caused by servicing many clients.
B. Provides complete redundancy and high availability at all times.
C. Multiple copies are available in case a server crashes or goes offline.
D. Allows the databases on one server to be made available on another server.

문제 #2

Granting access to the mysql database...

A. Should never be done for any users.
B. Should always be done for all users.
C. Should be done for anyone needing to create views
D. Should only be done on administrator accounts.

문제 #3

Which of the following statements are required to create a key cache of 4 MB, assign the
MyISAM table world.City to it and preload the index?

A. Mysql> SET GLOBAL city_cache.key_buffer_size = 4194304; mysql> CACHE INDEX world.City IN city_cache; mysql> LOAD INDEX INTO CACHE world.City;
B. It is not possible to create a key cache for a specific MyISAM table, only the global key cache can be used.
C. Mysql> ALTER TABLE world.city KEY_CACHE = 4194304;
D. Mysql> CREATE CACHE FOR world.City SIZE = 4194304;

문제 #4

Which of the following best describes how the relay log works?

A. It records the times when the slave connects to the master.
B. When a slave receives a change from the master, it is recorded in the relay log first and processed later.
C. When a slave receives a change from the master, it is processed first and then recorded in the relay log.

문제 #5

Which of the following best describes the purpose of the record buffer (as controlled through the read_buffer_size variable), and how it is set? (Choose two)

A. The record buffer is used for operations such as ORDER BY or GROUP BY.
B. The record buffer is global and is only set by restarting the server.
C. The record buffer is set per connection.
D. The record buffer is used to perform sequential table scans, reducing the number of reads from disk

질문과 대답: