[Q10-Q32] 100%合格率リアル1Z0-908試験成功を掴み取れ！[2023年07月]

100%合格率リアル1Z0-908試験成功を掴み取れ！[2023年07月]

Oracle 1Z0-908のPDF問題格別な練習MySQL 8.0 Database Administrator

質問 # 10
You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

A. Restore using the --set-gtid-purged=OFF option.
B. Remove the group replication plugin from each instance before restoring.
C. Create the backup by using the --set-gtid-purged=OFF option.
D. Remove the @@GLOBAL.gtid_purged statement from the dump file.
E. Remove the @@GLOBAL.gtid_executed statement from the dump file.
F. Stop all instances except the primary read/write master instance and run the restore.

正解：C、D

質問 # 11
Examine this query and its output:

Which two statements are true? (Choose two.)

A. The app user had the highest total number of rows read from storage engines.
B. The root user had the largest number of modified rows for a SELECT statement.
C. The root user had the largest single wait time.
D. User bob had the largest total time waiting for locks.
E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

正解：A、E

質問 # 12
You are upgrading a MySQL instance to the latest 8.0 version.
Examine this output:

You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

A. It defines all innodb tablespace options relative to a starting parent directory.
B. It allows scanning of other locations to discover more innodb tablespaces.
C. It is not necessary because innodb_data_home_dir is already defined.
D. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
E. It adds more temporary workspace in addition to the innodb_tmpdir location.

正解：B

解説：
Explanation
https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

質問 # 13
Examine the modified output:

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

A. The master is most probably too busy to transmit data and the slave needs to wait for more data.
B. The parallel slave threads are experiencing lock contention.
C. The master is producing a large volume of events in parallel but the slave is processing them serially.
D. This value shows only I/O latency and is not indicative of the size of the transaction queue.
E. One or more large tables do not have primary keys.

正解：C、D

質問 # 14
Which two are features of MySQL Enterprise Firewall? (Choose two.)

A. modifying SQL statement dynamically with substitutions
B. blocking of potential threats by configuring pre-approved whitelists
C. provides stateless firewall access to TCP/3306
D. automatic locking of user accounts who break your firewall
E. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

正解：B、E

質問 # 15
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'.
(RuntimeError)
Which statement is true?

A. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
B. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
C. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
E. The cluster is running and there is at least one ONLINE instance.

正解：A

質問 # 16
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

A. The DBA needs to execute FLUSH PRIVILEGES.
B. John has not activated the role.
C. John needs to reconnect to the database.
D. The statement was blocked by MySQL Firewall.

正解：B

質問 # 17
You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

A. *.ibd files
B. *.sdi files
C. *.CSM files
D. ib_logfile* files
E. ibbackup files

正解：A、D

質問 # 18
Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema() Which two statements are true? (Choose two.)

A. Connections driven by MySQL Router are not affected by the command.
B. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
C. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
E. Group Replication will be dissolved and all metadata purged.
F. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

正解：A、B

質問 # 19
Which two queries are examples of successful SQL injection attacks? (Choose two.)

A. SELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
'secret');--';
B. SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
C. SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
D. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
E. SELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('[email protected]','secret');--';
F. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

正解：A、F

質問 # 20
You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

A. It creates a logical backup of all MySQL user accounts.
B. It returns an error because the mysqldump command should have been used.
C. It creates a logical backup of only the users database.
D. It creates a logical backup of all metadata, but contains no table data.

正解：A

解説：
Explanation
the command mysqlpump --exclude-databases=% --users creates a logical backup of all MySQL user accounts as CREATE USER and GRANT statements2. The option --exclude-databases=% excludes all databases from the backup, while the option --users includes all user accounts1.

質問 # 21
Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

A. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
B. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
C. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
D. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

正解：C

質問 # 22
Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

A. SOCKET
B. FILE
C. MEMORY
D. IPv4
E. IPv6
F. PIPE
G. TCP
H. DIRECT

正解：A、C、F、G

質問 # 23
Which two statements are true about the mysql_config_editor program? (Choose two.)

A. It will use [client] options by default unless you provide --login-path.
B. It can move datadir to a new location.
C. It provides an interface to change my.cnf files.
D. It manages the configuration of user privileges for accessing the server.
E. It manages the configuration of client programs.
F. It manages the configuration of the MySQL Firewall feature.
G. It can be used to create and edit SSL certificates and log locations.

正解：A、E

質問 # 24
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

A. The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;
B. The slave needs to be restored from backup.
C. The relay logs from the master should be used to replace the corrupted relay logs.
D. The slave relay logs should be deleted; then execute START SLAVE;

正解：C

質問 # 25
Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. doublewrite buffer
B. InnoDB Data Dictionary
C. change buffer
D. user privileges
E. primary indexes
F. table data

正解：A、B

解説：
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/innodb-system-tablespace.html

質問 # 26
Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
B. Mark can revoke the r_read@localhost role from another role.
C. Mark can grant the r_read@localhost role to another user.
D. ADMIN OPTION causes the role to be activated by default.
E. Mark must connect from localhost to activate the r_read@localhost role.
F. ADMIN OPTION allows Mark to drop the role.

正解：B、C

解説：
Explanation
https://dev.mysql.com/doc/refman/8.0/en/grant.html

質問 # 27
Examine this query and output:

Which two statements are true? (Choose two.)

A. The query returns exactly 125 rows.
B. The country table is accessed as the first table, and then joined to the city table.
C. The optimizer estimates that 51 rows in the country table have Continent = 'Asia'.
D. It takes more than 8 milliseconds to sort the rows.
E. 35 rows from the city table are included in the result.

正解：C、E

質問 # 28
Examine this command and output:

Which two statements are true? (Choose two.)

A. The lock is an intentional lock.
B. The lock is a shared lock.
C. The lock is an exclusive lock.
D. The lock is a row-level lock.
E. The lock is at the metadata object level.
F. The lock is at the table object level.

正解：C、F

質問 # 29
Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%';
B. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
C. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
D. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

正解：A

質問 # 30
Which two are use cases of MySQL asynchronous replication? (Choose two.)

A. It allows backup to be done on the slave without impacting the master.
B. You can scale writes by creating a replicated mesh.
C. MySQL Enterprise Backup will automatically back up from an available slave.
D. You can scale reads by adding multiple slaves.
E. It guarantees near real-time replication between a master and a slave.

正解：A、D

質問 # 31
Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?