[2026] Oracle MySQL 5.6 Database Administrator - 1z1-883 무료 시험 문제

문제1

In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?

A. Syntax when writing queries involving JOINS

B. Character set mapping index hash size

C. Memory usage when working with the data

D. Comparing the encoded data with similar columns on other tables

E. Disk usage when storing data

정답: B,C,D

문제2

Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?

A. NAME="Error"
STATUS="0"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

B. NAME="Query"
STATUS="1146"
SQLTEXT=" Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

C. NAME="Error"
STATUS="1146"
SQLTEXT="select user,host from users"/>

D. NAME="Query"
STATUS="1146"
SQLTEXT="select user,host from users"/>

E. NAME="Error"
STATUS="1146"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

정답: D

문제3

Which three are properties of the MyISAM storage engine?

A. FULLTEXT indexing for text matching

B. Transaction support

C. Geospatial indexing

D. Table and page level locking support

E. Table level locking only

F. Foreign key support

G. HASH index support

정답: A,C,E

문제4

You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?

A. The command prints all parameter for the login-path. The password is replaced with stars.

B. The command prints all parameters for the login-path. The password is shown only when you provide the -password option.

C. The command prints all parameters for the login-path. The password is printed in plain text.

D. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.

정답: A

문제5

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?

A. It implements High Availability by using the .NET Connector's load balancing capabilities.

B. It is shared-nothing architecture.

C. It relies on the shared disk architecture being visible to both servers.

D. It is provided by means of IP- level disk replication.

정답: C

문제6

Which three statements are true about memory buffer allocation by a MySQL Server?

A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.

B. Thread buffers are allocated when a client connects, and are freed when the client disconnects.

C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.

D. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.

E. User buffers are allocated at server startup and freed when the user is dropped.

정답: A,B,C

문제7

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. -- skip-buffer

B. -- single-transaction

C. -- tab

D. -- quick

정답: D

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

문제8

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?

A. Distributed Replication Block Device

B. MySQL Replication

C. MySQL Cluster

D. Windows Server Failover Clustering

정답: B

문제9

Which three statements are characteristic of the MEMORY storage engine?

A. It can support transactions

B. It can support foreign keys.

C. Table contents are not saved if the server is restarted.

D. It cannot contain text or BLOB columns.

E. Each table has a corresponding.MYI and .MYD file.

F. Each table is represented on disk as an.frm file.

정답: C,D,F

문제10

You want a record of all queries that are not using indexes.
How would you achieve this?

A. By enabling the Error Log and using the - log-queries-not-using-indexes option

B. By enabling the Error Log because not using indexes is an error

C. By enabling the Slow Query Log and using the - log-queries-not-using-indexes option

D. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

정답: C

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

Oracle MySQL 5.6 Database Administrator - 1z1-883무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트