購入前に中身を確かめたい方は、GoShikenの無料サンプルをご活用ください。1Z0-888（Oracle MySQL 5.7 Database Administrator）の問題集は、実際の問題形式や解答の質をご確認いただいてからご購入いただけます。

Oracle 1Z0-888 試験概要:

Oracle 1Z0-888 試験シラバストピック:

1Z0-888試験に関するQ&Aまとめ

Oracle MySQL 5.7 Database Administrator 認定 1Z0-888 試験問題：

問題 #1

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a `SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

A. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC";
B. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";
C. SET GLOBAL enforce_gtid_consistency=ON
D. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
E. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

問題 #2

Which statement is true about tablespaces?

A. General tablespaces can be configured to span multiple files.
B. All tablespace files must be in the directory specified by the -datadir option.
C. All tables must be in either the system tablespace or a general tablespace.
D. The system tablespace can be configured to span multiple files.

問題 #3

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 binary logs in the backup.
B. Include the keyring data and/or configuration in the backup.
C. Copy the backup to a remote host.
D. Include the MySQL socket file in the backup.
E. Include the operating system disk encryption key in the backup.
F. Include the ibtmp1 file in the backup.
G. Include the MySQL PID file in the backup.
H. Include the relay logs in the backup.
I. Restore the backup to a clean MySQL instance.

問題 #4

On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100.000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

A. Use the limit clause in conjunction with the order 3Y clause.
B. Use the limit clause to limit the deletion to 100.000 rows.
C. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
D. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.

問題 #5

You have just executed a manual backup by using this command:
mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

A. Backup State = Prepared Backup
Operation = apply-log
B. Backup State = Compressed Backup
Operation = copy-back
C. Backup State = Prepared Backup
Operation = validate
D. Backup State = Raw Backup
Operation = apply-log
E. Backup State = Raw Backup
Operation = backupdir-to-image

解説：