[2022年01月] 無料1Z1-888試験問題集試験点数を伸ばそう
2022年最新の1Z1-888実際問題集には試験のコツがあるPDF試験材料
質問 62
Which statement best describes the purpose of the InnoDB buffer pool?
- A. It holds changes made during a transaction before they are written to the log.
- B. It caches only the indexes for InnoDB tables.
- C. It is amount of buffers available during a transaction.
- D. It caches data and indexes for InnoDB tables.
- E. It is a pool of memory for SQL query sort operations from within the InnoDB engine.
正解: D
質問 63
These details are shown when logged in to an account:
Which set of statements would match the accounts shown?
- A. mysql> CREATE USER `robert'@'localhost' IDENTIFIED BY `secret_password'; mysql>CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets';
- B. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON `employee'@'localhost' TO `robert'@'localhost';
- C. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> GRANT PROXY ON
`employee'@'localhost' TO ''@''; - D. mysql> CREATE USER `employee'@'localhost' IDENTIFIED BY `more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY `valid_password' WITH PROXY `employee'@'localhost';
正解: C
質問 64
Consider the key buffer in a MySQL server. Which two statements are true about this feature?
- A. It is a global buffer.
- B. It caches index blocks for all storage engine tables.
- C. It caches index blocks for MyISAM tables only.
- D. It caches index blocks for InnoDB tables only.
- E. It is set on a per-connection basis.
正解: C,E
解説:
Reference: https://stackoverflow.com/QUESTION NO:s/3663515/mysql-what-is-the-key- buffer
質問 65
This output is from a SHOW SLAVE STATUS:
What would cause the SQL_Delay variable to have a value of 360?
- A. The master has performed a large transaction, which will take 360 seconds to complete on the slave.
- B. The slave was configured for delayed replication with a delay of six minutes.
- C. The network latency between the master and the slave is 360 milliseconds.
- D. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
正解: B
質問 66
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
- A. THREAD_ID 21has stopped running.
- B. At most, two schemas are being updates concurrently.
- C. The slave is configured with slave_parallel_workers= 4
- D. The server needs more cores to use all slave threads.
- E. The slave cannot process the relay log fast enough to use all threads.
- F. The slave has two intermediate relay slaves connected to it.
正解: C,E
質問 67
Assuming that a user has correct privileges, which Linux console command will fail to shut down a MySQL server?
- A. mysql -e 'shutdown'
- B. service mysqld stop
- C. mysqld -e 'shutdown'
- D. mysqladmin shutdown
正解: C
質問 68
You have just created a replication slave from a backup of the master made with mysqldump:
You try to log in to the slave with the application user, but fail as follows:
The login works on the master.
Which two changes to the process can fix the issue?
- A. Add a second dump for the 'mysql' database; --all-databasesdoes not include it.
- B. Use the --grantsoption to include GRANTstatements in the dump.
- C. After the restore, log in to the database and execute FLUSH PRIVILEGES.
- D. Use the --flush-privilegeswith mysqldump.
正解: A
解説:
Explanation/Reference:
質問 69
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
- A. to allow a backup to be created under reduced load
- B. to allow for point-in-time recovery on the slave
- C. to prevent schema changes from propagating to the slave before they are validated
- D. to allow the remaining events to be processed on the slave while not receiving new events from the master
- E. to prevent any transaction experiencing a deadlock
正解: A,B
質問 70
Which two methods accurately monitor the size of your total database size over time?
- A. monitoring the innodb_redo_log_size variable
- B. monitoring datadir size in the operating system
- C. monitoring the information_schemA.TABLES table
- D. monitoring cumulative Innodb_page_size increase
- E. monitoring the performance_schema_hosts_size variable
- F. monitoring the Innodb_rows_inserted status variable
正解: C,E
質問 71
A MySQL database uses all InnoDB tables and is configured as follows;
You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)
- A. --master-data
- B. --skip-opt
- C. --single-transaction
- D. --lock-all-tables
- E. --create-apply-log
正解: B,D
質問 72
You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:
What would you run to fix the issue?
- A. the mysql client with the --ignore-password-hashing option
- B. the install plugin command for the mysql_cleartext_password plugin
- C. the mysql_secure_installation script to update server security settings
- D. the mysql_upgrade script
- E. the mysql client with the --enable-cleartext-plugin option
正解: C
質問 73
To query two system variables, you execute this statement and get the results shown:
When you execute the following two statements, only the first one succeeds:
SET @@autocommit=0;
SET @@max_connections=200;
Why does the second statement fail?
- A. max_connections must be set at server start in an options file.
- B. max_connections is a read-only variable that cannot be set dynamically.
- C. max_connections must be set globally instead of locally.
- D. max_connections is a derived variable that can only be set indirectly.
正解: A
質問 74
After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:
What are the two most likely reasons for the slowness given this output?
- A. The User field is too long for most names.
- B. Date should be a TIMESTAMP field for better performance.
- C. No indexes are defined.
- D. Using default values for DATETIME causes table scans.
- E. The engine type is not appropriate to the application use.
正解: C,E
質問 75
Consider the index information for the dept_emp table in the employee's schema:
Which two conclusions can be made based on the output of the query? (Choose two.)
- A. The secondary indexes are optimized for unique key look-ups.
- B. There are three indexes on the table.
- C. There is a redundant index on the dept_no column.
- D. The selectivity of the dept_no column is the best of the indexed columns.
- E. There is a redundant index on the emp_no column.
- F. The values on the emp_no column must be unique.
正解: A,E
質問 76
Consider:
Which statement best describes the meaning of the value for the key_len column?
- A. It shows the number of characters indexed in the key.
- B. It shows how many bytes will be used from each index row.
- C. It shows how many columns in the index are examined.
- D. It shows the total size of the index row.
正解: B
質問 77
old_alter_tableis disabled as shown.
mysql> SELECT @@old_alter_table;
Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
- A. All data in p1 and p3 partitions is removed and the table definition is changed.
- B. It results in a syntax error because you cannot specify more than one partition in the same statement.
- C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
- D. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
正解: D
質問 78 
What does the possible_keys column in this output denote?
- A. whether you are using any indexes in your query
- B. if it is possible for you to include any indexes in your query
- C. whether there are any indexes on the tables that you are querying
- D. if there are any indexes that may be used to solve this query
正解: B
質問 79
You are investigating the performance of a query which selects data from an InnoDB table.
Consider this Performance Schema diagnostics output for the query:
Which statement is true about the output?
- A. The query did not find its table in the table definition cache.
- B. The event with event_id = 8945 is a child of the event with event_id=8944.
- C. The query read data from the data file rather than directly from the buffer pool.
- D. The time the query took is the sum of all timer_wait values.
正解: A
質問 80
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
- A. THREAD_ID 21has stopped running.
- B. At most, two schemas are being updates concurrently.
- C. The slave is configured with slave_parallel_workers= 4
- D. The server needs more cores to use all slave threads.
- E. The slave cannot process the relay log fast enough to use all threads.
- F. The salve has two intermediate relay slaves connected to it.
正解: C,E
質問 81
Consider:
Which statement best describes the meaning of the value for the key_len column?
- A. It shows the number of characters indexed in the key.
- B. It shows how many bytes will be used from each index row.
- C. It shows how many columns in the index are examined.
- D. It shows the total size of the index row.
正解: B
質問 82
Examine the mysqldumpslow output:
Which two options could explain the slow query?
- A. A full table scan is being used.
- B. No index has been defined on the filtered column.
- C. There are 108 queries still being executed.
- D. A table lock is causing delays.
- E. There is network congestion between client and server.
正解: A,E
質問 83
......
Oracle 1Z1-888 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
| トピック 12 |
|
心強い1Z1-888のPDF問題集は1Z1-888問題：https://www.goshiken.com/Oracle/1Z1-888-mondaishu.html