Oracle 1Z0-908 問題集

質問 1：
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?
A. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
B. Replication will work.
C. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
E. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
正解：E

質問 2：
Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)
A. Remove group read/write privileges from the private_key.pem file.
B. Remove the world read/execute privilege from the accounting directory.
C. Remove world read privileges from the server-cert.pem certificate file.
D. Remove world read privileges from the public_key.pem file.
E. Change the parent directory owner and group to mysql.
F. Change the group ownership of the mysql directory to the mysql user group.
正解：E,F

質問 3：
Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)
A. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
B. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
C. InnoDB tablespaces outside the datadir are able to be cloned.
D. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
E. The account used to perform this recovery needs the BACKUP_ADMIN privilege.
F. It is always slower than {recoveryMethod: 'incremental'}.
正解：A,E,F

質問 4：
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
A. InnoDB
B. MEMORY
C. MyISAM
D. ARCHIVE
E. NDB
正解：B,C

質問 5：
Examine this command, which executes successfully:

Which two statements are true? (Choose two.)
A. The backup operation will finish only when apply-log is executed.
B. The backup operation will finish only when backup-and-apply-log is executed.
C. A raw backup is created.
D. The --backup-dir option holds temporary output, status, and metadata files.
E. A single-file backup is created.
正解：A,D