최신 1Z1-888 무료덤프 - Oracle MySQL 5.7 Database Administrator

문제1

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

A. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";

B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";

C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

D. SET GLOBAL enforce_gtid_consistency=ON

E. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

정답: C

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

문제2

Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

A. ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);

B. ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);

C. ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);

D. ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);

정답: B

문제3

Consider the table people with the definition:

The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index?

A. Add FORCE INDEX (Birthday) to the query.

B. Execute ANALYZE TABLE to update the index statistics.

C. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

D. Add a generated column calculating YEAR(Birthday) and index that column.

E. Add a functional index for YEAR(Birthday).

정답: A,C

문제4

You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?

A. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';

B. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';

C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman';

D. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';

E. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman';

F. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';

정답: A,B

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

문제5

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. --tab

C. --single-transaction

D. --quick

정답: D

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

문제6

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

A. server_id is not unique.

B. The max_connections variable on the slave needs to be increased.

C. The log_bin variable is set to OFF on the slave.

D. The version of the slave is newer that the version of the master.

E. The shared_memory_base_name variable must match the master.

정답: C

문제7

You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

A. You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.

B. The statement would fail because you cannot update more than one row at a time when using ?
binlogformat = ROW.

C. Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.

D. The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW

E. Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

정답: C,E

문제8

SQL injection is a common security threat.
Which two methods would help protect against this risk? (Choose two.)

A. installing the SQL Protection plugin to catch such attempts

B. using prepared statements to handle unsecured values

C. using SQL variables to secure input values

D. using stored procedures to validate values that are input

E. starting the server with the -injection-protection command-line option.

정답: C,D

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

문제9

Multiversion Concurrency Control (MVCC) enables what type of backup?

A. Binary

B. Logical

C. Hot

D. Incremental

정답: C

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

문제10

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 difference between the InnoDB status values "Log Sequence number" and "Last Checkpoint" positions then compare that to the total size of the redo log.

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

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

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 difference between the InooDB status values "Trx id counter" and "Purge done for" and compare to the state substatus of the main "Main thread"

정답: A,B

최신 1Z1-888 무료덤프 - Oracle MySQL 5.7 Database Administrator

우리와 연락하기

유용한 링크

최신 업데이트