1Z1-888試験無料問題集（155題）「Oracle MySQL 5.7 Database Administrator 認定」

出題：1

You have been tasked with creating a QA MySQL instance on a DB host, which already has one large instance in /var/lib/mysql/running as the mysqluser. The MySQL configuration file for the existing instance includes:

The default instance was installed using the OS package manager. The latest binaries for both client and server are already in ENV PATH.
The new instance will run as a different user from the existing instance for security purposes.
You create the new data directory successfully and move on to initialize the new DATADIR.
You verify the output to confirm the operation's success:
[mysqlQA@linux /var/lib/]$ mysqld --initialize --datadir=/var/lib/mysql_QA 2>&1 | tail -n3
2018-05-03T12:16:10.928809Z 0 [ERROR] Could not open file '/var/log/mysqld.log' for error logging:
Permission denied
2018-05-03T12:16:10.928841Z 0 [ERROR] Aborting
[mysqlQA@linux /var/lib/]$
The initialization of the instance has failed.
What would you do to enable the initialization to succeed?

A. Use mysql_install_db.

B. Pass --log-error=/var/lib/mysql_QA/mysqld.log.

C. Change permissions on /var/log/mysqld.log to allow writes.

D. Use --no-defaults to ignore the existing config file in the default PATH.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

What is the order of tables shown in an EXPLAIN output?

A. It lists tables from the smallest to the largest.

B. It lists tables from the most optimized to the least optimized.

C. It lists tables in the order in which they are specified in the statement that is being explained.

D. It lists tables in the order in which their data will be read.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Consider:

Which statement best describes the meaning of the value for the key_len column?

A. It shows the total size of the index row.

B. It shows how many columns in the index are examined.

C. It shows how many bytes will be used from each index row.

D. It shows the number of characters indexed in the key.

正解：C 解答を投票する

出題：4

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

A. mysqlaccess

B. mysqldumpslow

C. mysqldump

D. mysqlslow

E. mysqlshow

正解：B 解答を投票する

出題：5

Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)

A. Only the password for active account can be changed.

B. All users have unrestricted access.

C. All connections succeed regardless of the username and password.

D. MySQL becomes read-only except for setting passwords.

E. User authentication is based on the operating system username.

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Where does MySQL Linux RPM install the mysqld binary?

A. /usr/local/mysql/bin/

B. /opt/mysql/server/bin/

C. /usr/libexec/

D. /usr/sbin/

E. /usr/bin/

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：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] and [mysqld]

B. [mysql] and [mysqladmin]

C. [mysqladmin]

D. [mysql]

E. [mysqld] and [mysqladmin]

F. [mysqld]

G. [mysql] and [mysqld] and [mysqladmin]

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

A. Invoke mysql with the --initialize option.

B. Run the create_system_tables.sql file

C. Run the mysql_unpack.sql file

D. Invoke mysqld with the --initialize option.

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

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; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;

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

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

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

正解：B 解答を投票する

出題：10

Which two statements describe how InnoDB recovery works?

A. There will in general be lost committed transactions after a crash using the default settings.

B. It is recommended to set innodb_force_recovery = 1 as part of normal operations.

C. InnoDB handles most crash recoveries automatically.

D. It is always required to enable innodb_force_recovery to perform a crash recovery.

E. It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.

F. InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.

正解：D,F 解答を投票する

出題：11

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

A. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@'';

B. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';

C. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';

D. mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';

正解：A 解答を投票する

1Z1-888試験無料問題集「Oracle MySQL 5.7 Database Administrator 認定」