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

出題：1

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?

A. The server suspends operations for all storage engines until space becomes available.

B. An error message will be returned to the client .Server Error: ER_IO

C. The server suspends that INSERT operation until space becomes available.

D. The server will crash.

正解：C 解答を投票する

出題：2

You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
Which procedure would you execute from a MySQL prompt?

正解：C 解答を投票する

出題：3

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. shell> mysqladmin recover test dump.sql

B. shell> mysqlimport test dump.sql

C. shell> mysql test < dump.sql

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

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

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

出題：4

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

A. executing REVOKE FILE FROM *_*

B. setting the --local-infile=0 option when starting mysqld

C. setting the --local-service=0 option when starting mysqld

D. setting the --open-files-limit=0 option when starting mysqld

E. executing REVOKE FILE ON *_* FROM ` `@'%'

F. executing REVOKE LOAD FROM *.*

正解：D 解答を投票する

出題：5

Which statement is correct about how InnoDB storage engine uses disk space?

A. It stores data in .MYD files, index information in .MYI files, and undo information in the common tablespace.

B. It stores data, index and undo information in tablespace file(s).

C. It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

D. It stores data in .MYD files and its index and undo information in the common tablespace.

E. It stores its data, index and undo information in .MYD and .MYI files.

正解：B 解答を投票する

出題：6

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. Lower innodb_max_dirty_pages_pct to flush more often.

B. Increase the size of redo logs.

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

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

正解：A 解答を投票する

出題：7

A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?

A. binary log, redo log, doublewrite buffer, and tablespace

B. redo log, binary log, doublewrite buffer, and tablespace

C. doublewrite buffer, redo log, tablespace, and binary log

D. redo log, doublewrite buffer, tablespace, and binary log

正解：A 解答を投票する

出題：8

Which two general properties relate to the mysqlimport client program? (Choose two.)

A. It can be used to easily import full binary backups.

B. It can load files only on the server host.

C. It bypasses the server and writes directly to the data files.

D. It can load files both on the client host and the server host.

E. It provides a command-line interface to the LOAD DATA INFILE.

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

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

出題：9

You have a scheduled task on Linux that executes mysqldumpagainst the localhost server periodically.
When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning.
The command the scheduled task is executing as follows:
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --protocol=TCP
> /backups/latest.sql
Warning: Using a password on the command-line interface can be insecure.
Which two methods are available to avoid the warning? (Choose two.)

A. Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.

B. Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
[client]
password=t100043va

C. Connect through the --socket rather than the default --protocol=TCP for local connection.
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --socket=/tmp/mysql.sock > /backups/ latest.sql

D. Use the password validation plugin available to improve user name and password strength.

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

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

出題：10

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO `webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO `webadmin'@'%';
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

A. The stored procedure named get_reports will be dropped.

B. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.

C. The user will get an error because he or she did not put the database name in front of the stored procedure name.

D. The user will get an error because he or she does not have the permission to drop stored procedures.

正解：A 解答を投票する

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