[2026] Oracle MySQL 5.7 Database Administrator - 1Z1-888 무료 시험 문제

문제1

What is the best method for monitoring Group Replication conflict resolution?

A. the SHOW PROCESSLIST command

B. the PERFORMANCE_SCHEMA tables

C. the INFORMATION_SCHEMA tables

D. the SHOW STATUS command

E. the INNODB Lock Monitor details

정답: B

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

문제2

While attempting to set up a new replication slave on host `192.168.0.25' with the user `replication', you encounter this error:

What should you do to resolve this error?

A. Add the user [email protected] with the correct password to the slave.

B. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.

C. Add the user [email protected] with the correct password to the master.

D. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.

정답: C

문제3

Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server's health and performance?

A. Move redo logs to /dev/shm to improve their speed.

B. Lower innodb_max_dirty_pages_pct to flush more often.

C. Reduce the size of redo logs to improve storage efficiency.

D. Increase the size of redo logs.

정답: B

문제4

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
- It must be possible to rebuild the instance using the backup.
- It must be verified.
- It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

A. Include the keyring data and/or configuration in the backup.

B. Include the MySQL socket file in the backup.

C. Copy the backup to a remote host.

D. Include the binary logs in the backup.

E. Include the MySQL PID file in the backup.

F. Include the ibtmp1 file in the backup.

G. Include the operating system disk encryption key in the backup.

H. Include the relay logs in the backup.

I. Restore the backup to a clean MySQL instance.

정답: C,E,G,H

문제5

The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.
Which three statements will succeed when executed by [email protected]? (Choose three.)

A. GRANT INSERT ON audit.* TO [email protected];

B. GRANT DELETE ON world.* TO [email protected];

C. GRANT SELECT ON audit.* TO [email protected];

D. GRANT SELECT ON world.* TO [email protected];

E. GRANT SELECT ON world.* TO [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

F. GRANT SELECT ON world.* TO [email protected];

G. CREATE USER [email protected] IDENTIFIED BY '^jkK2@9bqLm4!jlaN';

정답: A,B,G

문제6

You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

A. Remove all of the binary log files that have a modification date earlier than today.

B. Ensure that none of the attached slaves are using any of the binary logs you want to delete.

C. Execute the PURGE BINARY LOGS NOT USED command.

D. Edit the .index file to remove the files you want to delete.

E. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

정답: B,E

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

문제7

A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)

A. disabling connections from named pipes or socket files (depending on the operating system of the server)

B. running the server with -skip-networking specified

C. installing MySQL on the application server, and running the database and application on the same server

D. starting the server with -bind-address=0.0.0.0 specified

E. enabling and using SSL for connections to the MySQL database

F. limiting logins to originate from the application server or the server's subnet

정답: C,E

문제8

You are using the mysqldumpslow utility to view the contents of the slow query log.
You notice the letter N and the character string `S' in a number of locations in the output.
What does the N indicate?

A. an abstracted substitution for numbers indicated in WHERE clauses

B. an abbreviation for NULL in a statement

C. the name of the user issuing the statement

D. the number of times the statement was executed

정답: D

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

문제9

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

A. to allow the remaining events to be processed on the slave while not receiving new events from the master

B. to allow for point-in-time recovery on the slave

C. to prevent schema changes from propagating to the slave before they are validated

D. to allow a backup to be created under reduced load

E. to prevent any transaction experiencing a deadlock

정답: B,D

문제10

Consider the ANALYZE TABLE command.
In which two situations should this command be used?

A. after large amounts of table data have changed

B. when you want to check a tables structure to see if it may have been damaged and needs repair

C. when you need to find out why a query is taking a long time to execute

D. when you want to update index distribution statistics

정답: A,D

문제11

You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?

A. the length of time before a newly created password expires

B. whether a new password is rejected if it contains the current user's username.

C. whether a new password is rejected if it contains a word found in a dictionary file.

D. the amount of delay after an incorrect password is entered

정답: C

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

문제12

Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

A. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com

B. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so';

C. SET GLOBAL mysql_cleartext_passwords=1;

D. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com

E. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'

정답: A,C

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

문제13

Which statement best describes the purpose of the InnoDB buffer pool?

A. It holds changes made during a transaction before they are written to the log.

B. It caches data and indexes for InnoDB tables.

C. It is amount of buffers available during a transaction.

D. It is a pool of memory for SQL query sort operations from within the InnoDB engine.

E. It caches only the indexes for InnoDB tables.

정답: B

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

문제14

You created a backup of the world database with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql?

A. mysql> USE test; mysql> LOAD DATA INFILE `dump.sql';

B. mysql>USE test; mysql>SOURCE dump.sql;

C. shell> mysql test < dump.sql

D. shell> mysqlimport test dump.sql

E. shell> mysqladmin recover test dump.sql

정답: A,D

문제15

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid for why one of the users is unable to connect to the database?

A. Kay is already connected elsewhere and attempting to log in again.

B. All users are blocked because max_user_connections is accumulated over the host account information.

C. Bob has max_user_connections set to zero, which blocks all his connections.

D. Joe has exceeded the max_user_connections global limit.

E. connect_timeout is too small to allow a connection to occur.

정답: D

Oracle MySQL 5.7 Database Administrator - 1Z1-888무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트