1z0-883試験無料問題集（100題）「Oracle MySQL 5.6 Database Administrator 認定」

出題：1

When backing up a replication slave, which three should also be backed up in addition to data?

A. The relay log files

B. Mysql.slave_relay_log_info table

C. The relay index file

D. Mysql.slave_master_info table

E. The master.info and relay.info files

F. Mysql.slave_worker_info table

正解：A,B,E 解答を投票する

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

出題：2

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

A. The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.

B. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.

C. Multiple BIT columns pack tightly into a row, using less space.

D. BIT (8) takes less space than eight TINYINT fields.

正解：C 解答を投票する

出題：3

Following a server crash, the automatic recovery of InnoDB fails.
How would you begin to manually repair the InnoDB tables?

A. Start the server as usual, and then execute the REPAIR TABLE command.

B. Start the server with the - innodb_force_recovery option set to a non-zero value.

C. Start the server with the - innodb_recover_options option set to FORCE.

D. Start the server as usual, and then execute the CHECK TABLE command.

正解：B 解答を投票する

出題：4

You want a record of all queries that are not using indexes.
How would you achieve this?

A. By enabling the Slow Query Log and using the - log-queries-not-using-indexes option

B. By enabling the Error Log and using the - log-queries-not-using-indexes option

C. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

D. By enabling the Error Log because not using indexes is an error

正解：A 解答を投票する

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

出題：5

You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' connot be loaded: plugin not enabled
What would you run to fix the issue?

A. The mysql_secure_installation script to update server security settings

B. The mysql_upgrade script

C. The install plugin command for the mysql_cleartext_password plugin

D. The mysql client with the - ignore-password-hashing option

E. The mysql client with the - enable-cleartext-plugin option

正解：E 解答を投票する

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

出題：6

Which statement is true about the log-output variable?

A. It enables and starts the General Query Log.

B. It sets the target location for the binary logs generated by the MySQL sever.

C. It specifies output destinations for the slow and General Query logs.

D. It is a static variable and can be set only at MySQL server startup.

正解：C 解答を投票する

出題：7

You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?

A. FLUSH HOST CACHE;

B. FLUSH PRIVILEGES;

C. CREATE USER 'admin' @'%';

D. UPDATE mysql.user SET Create_user_priv = 'Y' WHERE user= 'admin';

E. GRANT USAGE ON *.* TO 'admin'@'%';

正解：B 解答を投票する

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

出題：8

Which three are properties of the MyISAM storage engine?

A. HASH index support

B. Geospatial indexing

C. FULLTEXT indexing for text matching

D. Transaction support

E. Foreign key support

F. Table and page level locking support

G. Table level locking only

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

出題：9

Which two events will cause a slave server to create a new relay log file?

A. Execution of the FLUSH LOGS statement

B. Execution of FULSH TABLES WITH READ LOCK

C. Starting of the I/O thread

D. Starting of the SQL thread

E. Reaching the slave_pendign _jobs_size_max limit

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

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

出題：10

Consider the MySQL Enterprise Audit plugin,
You add the following lines to the my.cnf configuration tile:
[mysqld]
Plugin-load=audit_log.so
Audit-log=FORCE_PLUS_PERMANENT
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?

A. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

B. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

C. The audit log file does not exist in which to write audit events.

D. The audit_log.so library does not exist.

E. The audit_log.so library is not an executable file.

F. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

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

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

1z0-883試験無料問題集「Oracle MySQL 5.6 Database Administrator 認定」