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

出題：1

You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave.
Which command would you execute from a Mysql prompt?

A. STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;

B. STOP SLAVE;
RESET SLAVE;
BEGIN;
SKIP NEXT GTID;
COMMIT;
START SLAVE;

C. STOP SLAVE;
BEGIN;
SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
COMMIT;
START SLAVE;

D. STOP SLAVE;
SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
BEGIN;
COMMIT;
SET GTID_NEXT="AUTOMATIC";
START SLAVE

正解：A 解答を投票する

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

出題：2

Which three data components are needed for point-in-time recovery?

A. Binary logs

B. The data backup

C. Configuration files

D. The error log

E. The general query log

F. The backup log

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

出題：3

A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?

A. They all connect via the secure sha256_password algorithm without any configuration change.

B. They will have to change their password the next time they login to the server.

C. They are not affected by this configuration change.

D. They will have their passwords updated on start-up to sha256_password format.

正解：A 解答を投票する

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

出題：4

Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?

A. NAME="Query"
STATUS="1146"
SQLTEXT=" Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

B. NAME="Error"
STATUS="0"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

C. NAME="Query"
STATUS="1146"
SQLTEXT="select user,host from users"/>

D. NAME="Error"
STATUS="1146"
SQLTEXT="select user,host from users"/>

E. NAME="Error"
STATUS="1146"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>

正解：C 解答を投票する

出題：5

The 'allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather the following information:
[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0
Three tables are stored in the innoDB shared tablespace and the details are as follows: -The table data_current has 1,000,000 rows.
-The table data_reports has 1,500,000 rows. -The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ...
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.
Shell> mysqldump - u root - p applicationdb data_archive > /backup/data_archive.sql
Mysql> DROP TABLE data_archive;
Which set of actions will allow you to free disk space back to the file system?

A. Set the server to use its own tablespace, and then alter the table so that data is moved from the
shared tablespace to its own:
Mysql> SET GLOBAL innodb_file_per_table=1;
Mysql> ALTER TABLE data_current ENGINE=InnoDB;
Mysql> ALTER TABLE data_repors ENGINE=InnoDB;

B. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the
file system:
Mysql> OPTIMIZE TABLE data_current, data_reports;

C. Enable compression on the table, causing InnoDB to release unused pages on disk to the file
system:
Mysql> SET GLOBLE innodb_file_per_table=1;
Mysql> SET GLOBLE innodb_file_format=Barramcuda;
Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
Mysql> ALTER TABLE data_history ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;

D. Take a backup, stop the server, remove the data files, and restore the backup:
Shell> mysqldump - u root -p applicationdb / > /backup/applicationdb.sql
Shell> /etc/init.d/mysql stop
Shell> cd /var/lib/mysql/
Shell> rm ibdata1 ib_logfile0 ib_logfile1
Shell> /etc/init.d/mysql start
Shell> mysql - u root - p applicationdb < /backup/applicationdb.sql

正解：D 解答を投票する

出題：6

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 STATUS indicates the following 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 RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

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

C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay-bin.00004' , RELAY_LOG_POS = 1383;

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

正解：D 解答を投票する

出題：7

Identify a performance impact when using the Performance Schema.

A. There is an overhead for querying the Performance Schema but not for having it enabled.

B. There is no impact on performance.

C. There is a constant overhead regardless of settings and workload.

D. The overhead depends on the settings of the Performance Schema.

正解：D 解答を投票する

出題：8

In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?

A. Comparing the encoded data with similar columns on other tables

B. Memory usage when working with the data

C. Disk usage when storing data

D. Syntax when writing queries involving JOINS

E. Character set mapping index hash size

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

出題：9

Which two statements are true regarding partitioning in Mysql?

A. Partitioning is only available for those storage engines that implements it natively.

B. Partitioning allows different columns to be stored in separate files.

C. Partitioning allows easier management of smaller data sets for certain queries.

D. The partitioning expression is an integer or function that returns an integer value or NULL value.

E. Tables with BLOB and TEXT columns cannot be partitioned.

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

出題：10

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?

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

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

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

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

E. Execute the PURGE BINARY LOGE NOT USED command.

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

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

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