1z1-908事前に試験練習テストで使おう（最新142問題) [Q25-Q47]

1z1-908事前に試験練習テストで使おう（最新142問題)

有効な1z1-908試験解答PDF一年無料更新

Oracle 1z1-908試験は、MySQL 8.0データベース管理の専門知識を証明したい個人を対象として設計されています。この試験は、すでにデータベース管理者として働いている個人や、この分野でキャリアを進めたい人々に最適です。この試験は、候補者のMySQL 8.0アーキテクチャ、管理、最適化技術の知識を測定します。

Oracle 1z1-908 試験を受験するには、データベース設計、SQL クエリ、データモデリングを含む関係データベースの深い知識が必要です。また、MySQL 8.0 データベースを本番環境で使用した経験が必要です。候補者は、大規模で複雑なデータベースの管理経験と、異なるデータベース管理タスクと方法論の理解を示す必要があります。

Oracle 1z1-908認定試験は、MySQL 8.0データベース管理者としてのスキルをアピールしたい個人を対象としています。この認定は、MySQLデータベースを管理および維持する責任があるデータベース管理者、開発者、およびその他のITプロフェッショナルに最適です。

 

質問 # 25
You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

• A. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
• B. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

正解：E

質問 # 26
Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

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

正解：A、C

質問 # 27
MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

• A. shell> mysql --print-defaults
• B. shell> mysqladmin --debug
• C. mysql> SHOW GLOBAL VARIABLES;
• D. shell> mysqld --help --verbose

正解：B

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

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

正解：B、D

質問 # 29
Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

• A. A deadlock occurs after innodb_lock_wait_timeout seconds.
• B. Connection 24 experiences a lock wait timeout.
• C. All statements execute without error.
• D. Connection 25 experiences a lock wait timeout.
• E. A deadlock occurs immediately.

正解：A

質問 # 30
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 is not necessary because innodb_data_home_dir is already defined.
• B. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• C. It adds more temporary workspace in addition to the innodb_tmpdir location.
• D. It defines all innodb tablespace options relative to a starting parent directory.
• E. It allows scanning of other locations to discover more innodb tablespaces.

正解：A

質問 # 31
Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

• A. world
• B. sys
• C. mysql
• D. employee
• E. information_schema

正解：B、E

解説：
Explanation/Reference: https://mysqlserverteam.com/introducing-mysqlpump/

質問 # 32
Which three are characteristics of a newly created role? (Choose three.)

• A. It can be granted to user accounts.
• B. It is created as a locked account.
• C. It can be protected with a password.
• D. It can be renamed using the RENAME ROLE statement.
• E. It is stored in the mysql.role table.
• F. It can be dropped using the DROP ROLE statement.

正解：A、C、F

解説：
Explanation
https://dev.mysql.com/doc/refman/8.0/en/roles.html
https://www.mysqltutorial.org/mysql-roles/

質問 # 33
Which three sets of item information are visible in the mysql system database? (Choose three.)

• A. audit log events
• B. plugins
• C. performance monitoring information
• D. help topics
• E. information about table structures
• F. time zone information and definitions
• G. rollback segments

正解：B、D、G

質問 # 34
Four nodes are configured to use circular replication.
Examine these configuration parameters for each node:

Which statement is true?

• A. Setting slave_preserve_commit_order to on will improve data consistency.
• B. Cross-database constraints can cause database inconsistency.
• C. Setting transaction_allow_batching to on will improve data consistency.
• D. Increasing slave_parallel_workers will improve high availability.
• E. Each slave thread is responsible for updating a specific database.
• F. Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.

正解：A

質問 # 35
Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

• A. The copy-back process is used to overwrite a new backup over an existing backup.
• B. The copy-back process makes inconsistent backups.
• C. It restores files from the backup directory to their original MySQL server locations.
• D. It restores files from the data directory to their original MySQL server locations.

正解：A、C

質問 # 36
Examine this query and output:

Which two statements are true? (Choose two.)

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

正解：C、D

質問 # 37
Which condition is true about the use of the hash join algorithm?

• A. The query must access no more than two tables.
• B. At least one of the tables in the join must have a hash index.
• C. No index can be used for the join.
• D. The smallest of the tables in the join must fit in memory as set by join_buffer_size.

正解：A

質問 # 38
User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• B. ALTER USER baduser@hostname DEFAULT ROLE NONE;
• C. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
• D. ALTER USER baduser@hostname PASSWORD DISABLED;
• E. ALTER USER baduser@hostname ACCOUNT LOCK;

正解：C、E

質問 # 39
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?

• A. Look for queries with low total latency times in the Latency section in the times series graph.
• B. Look for queries with big prolonged spikes in row activity/access graph in the times series graph.
• C. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values.
• D. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values.

正解：B

質問 # 40
Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

• A. Remove world read privileges from the public_key.pem file.
• B. Remove the world read/execute privilege from the accounting directory.
• C. Remove group read/write privileges from the private_key.pem file.
• D. Change the parent directory owner and group to mysql.
• E. Remove world read privileges from the server-cert.pem certificate file.
• F. Change the group ownership of the mysql directory to the mysql user group.

正解：D、F

質問 # 41
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 statement was blocked by MySQL Firewall.
• B. The DBA needs to execute FLUSH PRIVILEGES.
• C. John has not activated the role.
• D. John needs to reconnect to the database.

正解：C

質問 # 42
Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

• A. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
• B. Physical upgrades are much faster because they do not require restarting the mysqld process.
• C. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
• D. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
• E. Logical upgrades are much faster because they do not require restarting the mysqld process.
• F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

正解：E、F

質問 # 43
Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

• A. It is read and processed at the end of startup configuration.
• B. This file is for storing MySQL server_uuid values only.
• C. This file is for storing MySQL Server configuration options in ISON format.
• D. It is read and processed at the beginning of startup configuration.
• E. This file is for logging purposes only and is never processed.
• F. It is always updated with changes to system variables.

正解：A、F

質問 # 44
The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck.
Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

• A. innodb_flush_log_at_trx_commit=1
• B. max_connections=10000
• C. buffer_pool_size=24G
• D. innodb_doublewrite=0
• E. sync_binlog=0
• F. innodb_undo_directory=/dev/shm
• G. innodb_log_file_size=1G

正解：A、B、G

解説：
Explanation/Reference: https://aws.amazon.com/blogs/database/best-practices-for-configuring-parameters-for-amazon- rds-for-mysql-part-1-parameters-related-to-performance/

質問 # 45
Examine these statements and output:

Which statement is true?

• A. The user is authorized as the accounting@localhostuser.
• B. The user is authenticated as the anonymous proxy user ‘’@’%’.
• C. The user is logged in with --user=accountingas an option.
• D. The user failed to define a username and the connecting username defaulted to ‘’@’%’.
• E. The user is authorized as the rsmith@localhostuser.

正解：E

質問 # 46
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 moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.
• B. It adds more temporary workspace in addition to the innodb_tmpdir location.
• C. It defines all innodb tablespace options relative to a starting parent directory.
• D. It is not necessary because innodb_data_home_dir is already defined.
• E. It allows scanning of other locations to discover more innodb tablespaces.

正解：E

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

質問 # 47
......

MySQL 8.0 Database Administrator無料更新認定サンプル問題：https://www.jpntest.com/shiken/1z1-908-mondaishu

試験本場前にトレンドなOracle 1z1-908のPDF問題集を試そう：https://drive.google.com/open?id=1u37BfQA1GnUbcAV83x2NPVzPFlH5IgwP