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

문제1

A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?

A. It deletes all binary log files up to and including 'mysql-bin.010'.

B. It deletes all binary log files after 'mysql-bin.010'.

C. It deletes all binary log files before 'mysql-bin.010'.

D. It deletes all binary log files, except 'mysql-in.010'.

정답: C

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

문제2

Which two statements are true about setting the per-thread buffers higher than required?

A. It requires increasing the thread_cache_size variable.

B. It causes increased overhead due to initial memory allocation.

C. More memory per thread is beneficial in all scenarios.

D. It can affect system stability during peak load times, due to swapping.

정답: A,D

문제3

You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

A. The mysqld binary was not compiled with SSL support.

B. The --- ssl level was not specified.

C. The server's SSL certificate was invalid.

D. -- ssl is not a valid server option.

E. The server was not started with the - enable--ssl-plugin option.

정답: A

문제4

The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE 'validate_password%';

When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD ('Hoverl@%');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?

A. The password does not match the validate_passoword_number_count requirement.

B. All of the MEDIUM password policy requirements have not been honored.

C. There is no dictionary file defined, so password validation cannot work as expected.

D. The password is eight characters long, but needs to exceed validate_password_length to be valid.

E. The password matches a substring Hover as a dictionary word.

정답: B

문제5

Which two options describe how MySQL Server allocates memory?

A. Each connection may have its own per-thread memory allocations.

B. Thread memory is pre-allocated up to thread_cache_size for performance.

C. Each thread allocates memory from a global pool.

D. Global memory resources are allocated at server startup.

정답: A,D

문제6

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?

A. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

B. Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C. The slave database cannot have more columns than the master. Only the master database can have more columns.

D. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

E. Each extra column in the copy with more columns must not have a default value.

정답: A,B

문제7

You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.
Which statement will accomplish this?

A. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';

B. SELECT * FROM INFORMATION_SCHEMPROCESSLIST WHERE HOST='192.168.1.15';

C. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';

D. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

정답: B

문제8

You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows:
-The Mysql instance has 400 databases.
-Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
'ENGINE',
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
GROUP BY TABLE_SCHEMA, 'ENGINE'
;
Why is this query slow to execute?

A. Aggregating details from various storage engine caches for the final output is time consuming.

B. Collecting information requires various disk-level operations and is time consuming.

C. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.

D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.

정답: B

문제9

Which statement is true about FLUSH LOGS command?

A. It closes and reopens all log files.

B. It closes and sends binary log files to slave servers.

C. It requires the RELOAD, FILE, and DROP privileges.

D. It flushes dirty pages in the buffer pool to the REDO logs.

정답: A

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

문제10

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

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

우리와 연락하기

유용한 링크

최신 업데이트