최신Oracle MySQL 5.7 Database Administrator - 1Z0-888무료샘플문제

문제1
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

A. it contains the binary log.

B. it contains the undo log.

C. it is the default location for all new tables that you create.

D. it contains the system tablespace.

E. it contains a general tablespace.

F. it contains the redo log.

정답: C,D

설명: (ITDumpsKR 회원만 볼 수 있음)

문제2
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?

A. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

C. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

D. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

정답: D,E

문제3
Which three statements correctly describe MySQL InnoDB Cluster?

A. The data is automatically shared between the nodes.

B. The cluster can be operated in multimaster mode with conflict detection for DML statements.

C. All MySQL client programs and connectors can be used for executing queries.

D. There is support for automatic failover when one node fails.

E. It provides fully synchronous replication between the nodes.

F. Each query will be executed in parallel across the nodes.

정답: C,D,F

문제4
You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

A. 100% CPU use, 50% RAM

B. 10% CPU

C. 90% RAM

D. 9.1 five minute load average, 10% iowait

E. 100% iowait

F. 100% SWAP, 100% RAM

정답: A,F

문제5
Why should you be selective when granting the PROCESS privilege to an account?

A. It allows a client to process scripts.

B. It allows the use of stored routines.

C. It allows a client to control running processes on a server.

D. It allows a client to see another user's queries with the SHOW PROCESSLIST command.

정답: C

설명: (ITDumpsKR 회원만 볼 수 있음)

문제6
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. The server will crash.

B. An error message will be returned to the client .Server Error: ER_IO

C. The server suspends that INSERT operation until space becomes available.

D. The server suspends operations for all storage engines until space becomes available.

정답: C

문제7
You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

A. [mysql]

B. [mysql] and [mysqld] and [mysqladmin]

C. [mysql] and [mysqladmin]

D. [mysqld]

E. [mysqladmin]

F. [mysqld] and [mysqladmin]

G. [mysql] and [mysqld]

정답: A

설명: (ITDumpsKR 회원만 볼 수 있음)

문제8
You have issued this statement:
GRANT PROXY ON 'a' FOR 'b';
When user account 'b' issues a query, the query returns an access denied error.
What could have caused that error?

A. User account 'a' has not been granted permission to access the data being queried.

B. You have not set the proxy_user variable in the configuration file.

C. When connecting, user account 'b' is not entering the correct password for user account 'a'.

D. User account 'b' has not been granted permission to access the data being queried.

정답: C

설명: (ITDumpsKR 회원만 볼 수 있음)

문제9
Which two statements are true regarding MySQL security? (Choose two.)

A. The mysqld process should be run as root or administrator.

B. The mysqld process owner should own all files and directories to which the server writes.

C. The mysql user needs to have sudo privileges.

D. The mysqld process should not be run as root or administrator.

E. The root or administrator users should own all files and directories to which the server writes.

정답: D,E

문제10
Which three tasks are handled by the optimizer?

A. Parse the query.

B. Execute the query.

C. Verify that the user is allowed to execute the query.

D. Decide which indexes to use.

E. Change the order in which the tables are joined.

F. Validate the query.

G. Rewrite the WHERE clause.

정답: A,B,G

문제11
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 DNS is not configured correctly for slave1 host.

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 .mylogin.cnf file is not readable.

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

정답: D

문제12
Is it true that binary backups always take less space than text backups?

A. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.

B. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.

C. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.

D. Yes, because binary backups only contain data, and not statements required to insert data into the tables.

정답: A

문제13
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;

정답: C

문제14
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

A. --quick

B. --skip-buffer

C. --single-transaction

D. --tab

정답: A

설명: (ITDumpsKR 회원만 볼 수 있음)

자격증의 중요성:

ITDumpsKR 경쟁율이 심한 IT시대에 인증시험을 패스함으로 IT업계 관련 직종에 종사하고자 하는 분들에게는 아주 큰 가산점이 될수 있고 자신만의 위치를 보장할수 있으며 더욱이는 한층 업된 삶을 누릴수 있을수도 있습니다.

ITDumpsKR 제품의 가치:

ITDumpsKR에는 IT인증시험의 최신 학습가이드가 있습니다. ITDumpsKR의 IT전문가들이 자신만의 경험과 끊임없는 노력으로 최고의 학습자료를 작성해 여러분들이 시험에서 패스하도록 도와드립니다.

무료샘플 받아보기:

관심있는 인증시험과목 덤프의 무료샘플을 원하신다면 덤프구매사이트의 PDF Version Demo 버튼을 클릭하고 메일주소를 입력하시면 바로 다운받아 덤프의 일부분 문제를 체험해 보실수 있습니다.

완벽한 서비스 제공:

ITDumpsKR는 한국어로 온라인상담과 메일상담을 받습니다. 덤프구매후 일년동안 무료 업데이트 서비스를 제공해드리며 구매일로 부터 60일내에 시험에서 떨어지는 경우 덤프비용 전액을 환불해드려 고객님의 부담을 덜어드립니다.

인터넷에는IT인증시험대비자료가 헤아릴수 없을 정도로 많습니다.이렇게 많은 덤프자료중 대부분 분들께서 저희ITDumpsKR를 선택하는 이유는 덤프 업데이트가 다른 사이트보다 빠르다는 것이 제일 큰 이유가 아닐가 싶습니다.

유용한 링크

우리와 연락하기

근무시간: ( UTC+9 ) 9:00-24:00

월요일~토요일

서포트: 바로 연락하기

최신Oracle MySQL 5.7 Database Administrator - 1Z0-888무료샘플문제

자격증의 중요성:

ITDumpsKR 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공:

유용한 링크

인기 시험

우리와 연락하기