2022年05月最新のOracle 1Z1-888問題集で更新された155問あります
PDF無料ダウンロードには1Z1-888有効な練習テスト問題
Oracle 1Z1-888 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
| トピック 12 |
|
質問 84
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks.
What are the two major methods that will achieve this?
- A. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
- B. Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
- C. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
- D. Start the MySQL Server with -initialize-insecure to force a password reset procedure on the command line.
- E. Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
正解: B,E
解説:
Reference: https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
質問 85
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:
The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
- A. They will have to change their password the next time they login to the server.
- B. They will have their passwords updated on start-up to sha256_passwordformat.
- C. They all connect via the secure sha256_passwordalgorithm without any configuration change.
- D. They are not affected by this configuration change.
正解: D
質問 86
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?
- A. There is a redundant index on the emp_no column.
- B. The secondary indexes are optimized for unique key look-ups.
- C. There are three indexes on the table.
- D. The selectivity of the dept_no column is the best of the indexed columns.
- E. There is a redundant index on the dept_no column.
- F. The values on the emp_no column must be unique.
正解: A,B
質問 87
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:
You execute a 'SHOW CREATE TABLE mytable" on the slave:
The table mytable on the slave contains:
You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
- A. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
- B. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";BEGIN; COMMIT;SET GTID_NEXT="AUTOMATIC";
- C. SET GTID_NEXT="CONSISTENCY";BEGIN; COMMIT;SET GTID_NEXT="AUTOMATIC";
- D. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
- E. SET GLOBAL enforce_gtid_consistency=ON
正解: D
質問 88
You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?
- A. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
- B. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
- C. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
- D. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
正解: B
解説:
mysql> CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE; mysql -u erika -pfirst#1Pass -hlocalhost mysql> use db1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show variables;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
質問 89
You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
* Total dataset size is 200G with an average schema size of 2G.
* The data is transient and is not backed up and can be repopulated easily.
* Performance and responsiveness of the DB is paramount.
* The query pattern for the DB instance is split 90/10 read/write.
* DB host is dedicated server with 256G RAM and 64 cores.
One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)
- A. table_open_cache = 64
- B. query_cache_enabled=1
innodb_flush_log_at_trx_commit=0 - C. max_heap_table_size = 2G
- D. innodb_buffer_pool_size=200G
log_bin=mysql -bin - E. innodb_flush_method=O_DIRECT
- F. innodb_buffer_pool_instances=64
- G. tmp_table_size=2G
query_cache_size = 2G - H. Innodb_flush_log_at_trx_commit=1
sync_binlog=10
正解: A,E,F,G
質問 90
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?
- A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
- B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;
- C. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
- D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
正解: A
質問 91
Given these table definitions and the explain plan:
Which ALTER TABLE statement will improve the performance of the query?
- A. ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);
- B. ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);
- C. ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);
- D. ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);
正解: C
質問 92
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?
- A. it contains the binary log.
- B. it contains the system tablespace.
- C. it contains the undo log.
- D. it is the default location for all new tables that you create.
- E. it contains the redo log.
- F. it contains a general tablespace.
正解: B,D
質問 93
What is the order of tables shown in an EXPLAIN output?
- A. It lists tables in the order in which they are specified in the statement that is being explained.
- B. It lists tables from the most optimized to the least optimized.
- C. It lists tables from the smallest to the largest.
- D. It lists tables in the order in which their data will be read.
正解: A
解説:
Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
質問 94
SQL injection is a common security threat.
Which two methods would help protect against this risk?
- A. starting the server with the --injection-protection command-line option.
- B. using SQL variables to secure input values
- C. installing the SQL Protection plugin to catch such attempts
- D. using prepared statements to handle unsecured values
- E. using stored procedures to validate values that are input
正解: B,E
質問 95
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
- A. Invoke mysqld with the --initialize option.
- B. Run the mysql_unpack.sql file
- C. Run the create_system_tables.sql file
- D. Invoke mysql with the --initialize option.
正解: A
解説:
Reference:
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
質問 96
You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST.
Which three statements are true? (Choose three.)
- A. The performance impact is less than SHOW FULL PROCESSLIST.
- B. The PROCESS privilege is required.
- C. The events_statements_current consumer must be enabled.
- D. The sys.session view provides the process list with additional information.
- E. A connection must be instrumented to be included in the list of processes.
- F. The threads table contains all the required columns.
正解: B,C,F
解説:
The PROCESS privilege also enables use of SHOW ENGINE.
The threads table columns with names having a prefix of PROCESSLIST_ provide information similar to that available from the INFORMATION_SCHEMA.PROCESSLIST table or the SHOW PROCESSLIST statement.
Reference: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
https://www.percona.com/blog/2015/10/01/capture-database-traffic-using-performance-schema/
https://dev.mysql.com/doc/mysql-perfschema-excerpt/5.7/en/threads-table.html
質問 97
When you examine a new MySQL installation with default configuration, you find a file called ibdata1in the database directory. Which two statements are true about this file? (Choose two.)
- A. it contains the binary log.
- B. it contains the system tablespace.
- C. it contains the undo log.
- D. it is the default location for all new tables that you create.
- E. it contains the redo log.
- F. it contains a general tablespace.
正解: B,D
解説:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
質問 98
Which statement best describes the purpose of the InnoDB buffer pool?
- A. It caches only the indexes for InnoDB tables.
- B. It is amount of buffers available during a transaction.
- C. It holds changes made during a transaction before they are written to the log.
- 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
質問 99
An admin attempts to enforce stronger security by using these commands:
The admin then leaves the system running with the specified changes. What are two remaining security concerns?
- A. validate_password_policy cannot be set without restarting the MySQL instance.
- B. The validate_password plug-in has not been loaded.
- C. The name of the dictionary file is too obvious.
- D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.
- E. The dictionary file word list is too short.
- F. The dictionary file is an insecure location.
正解: C,F
質問 100
Which two statements are true regarding the creating of new MySQL physical and logical backups?
- A. Logical backups are always larger than physical backups.
- B. Physical backups are usually faster than text backups.
- C. Physical backups can be used to recover from data corruption.
- D. Logical backups are human-readable whereas physical backups are not.
- E. Physical backups are usually slower than text backups.
正解: B,C
解説:
Explanation/Reference:
質問 101
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
- A. server-id
- B. log_bin
- C. rpl-recovery-rank
- D. master-logging
- E. log-master-updates
- F. enable-master-start
正解: A,B
解説:
Explanation/Reference: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql
質問 102
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUSoutput:
You execute a 'SHOW CREATE TABLE mytable" on the slave:
The table mytable on the slave contains:
You have issued a STOP SLAVEcommand. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVEcommand to resolve the duplicate key error. Which statement should be used?
- A. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
- B. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC"; - C. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC"; - D. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
- E. SET GLOBAL enforce_gtid_consistency=ON
正解: D
解説:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html
質問 103
What two statements are true regarding FLUSH TABLES FOR EXPORT?
- A. The InnoDB Storage engine must be used for the table being exported.
- B. It can be used to export TEMPORARY tables.
- C. Table only exports when the table has its own tablespace.
- D. Partitioned tables are not supported.
- E. It is the safest way to extract tables from the shared tablespace.
正解: B,C
質問 104
Which three allocate memory per thread in MySQL?
- A. query cache
- B. sort buffer
- C. InnoDB buffer pool instance
- D. internal temporary table
- E. read buffer
- F. thread cache
正解: B,C,E
質問 105
You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)
- A. Remove all of the binary log files that have a modification date earlier than today.
- B. Edit the .index file to remove the files you want to delete.
- C. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.
- D. Execute the PURGE BINARY LOGS NOT USED command.
- E. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
正解: C,E
解説:
Explanation
A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file.
Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO 'log_name' | BEFORE datetime_expr }
質問 106
Which are three facts about backups with mysqldump? (Choose three.)
- A. are always faster to restore than binary backups
- B. allow a consistent backup to be taken
- C. will lock all storage engines for duration of backup
- D. create automatically compressed backups
- E. can back up a remote database server
- F. are able to back up specific items within a database
正解: B,E,F
質問 107
......
1Z1-888テストエンジンお試しセット、1Z1-888問題集PDF：https://jp.fast2test.com/1Z1-888-premium-file.html