Oracle 1Z0-908 問題集

質問 1：
Which three are requirements for a secure MySQL Server environment? (Choose three.)
A. Ensure appropriate file system privileges for OS users and groups.
B. Minimize the number of non-MySQL Server-related processes running on the server host.
C. Restrict the number of OS users that have access at the OS level.
D. Run MySQL server as the root user to prevent incorrect sudo settings.
E. Encrypt the file system to avoid needing exact file-system permissions.
F. Keep the entire software stack on one OS host.
正解：A,E,F

質問 2：
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)
A. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
B. Group Replication will be dissolved and all metadata purged.
C. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
D. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
E. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
F. Connections driven by MySQL Router are not affected by the command.
正解：A,F

質問 3：
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

質問 4：
Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)
A. All non-active binary logs are removed from the master.
B. All binary logs are backed up and then deleted.
C. All databases, excluding master metadata, are backed up to the output file.
D. All databases are backed up to the output file.
E. All details regarding deleted logs and master metadata are captured in the output file.
F. All binary logs are deleted from the master.
正解：C,F

質問 5：
All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled.
You must configure InnoDB Cluster to use SSL for group communication.
Which two statements are true? (Choose two.)
A. SSL group communication requires the use of an additional set of parameters group_replication_recovery_*.
B. An existing InnoDB Cluster must be dissolved and created from scratch to enable SSL for group communication.
C. If only some InnoDB Cluster members are enabled for SSL group communication, and
--ssl-mode=PREFERRED, communication will fall back to unencrypted connection.
D. Configuring SSL group communication also configures SSL distributed recovery.
E. SSL group communication must be enabled at cluster creation time by specifying createCluster ({memberSslMode: 'REQUIRED'}).
F. SSL group communication can be enabled for an existing cluster, one instance at time, by setting group_replication_ssl_mode.
正解：A,E