[2022年05月] 今すぐダウンロード！リアルOracle 1Z1-888試験問題集テストエンジン試験問題
最新1Z1-888テスト問題集を試そう！最新Oracle試験合格させます
Oracle 1Z1-888 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
質問 85
What is the best method for monitoring Group Replication conflict resolution?
- A. the INFORMATION_SCHEMA tables
- B. the INNODB Lock Monitor details
- C. the SHOW PROCESSLIST command
- D. the PERFORMANCE_SCHEMA tables
- E. the SHOW STATUS command
正解: D
質問 86
Consider:
Which statement best describes the meaning of the value for the key_len column?
- A. It shows how many columns in the index are examined.
- B. It shows the number of characters indexed in the key.
- C. It shows how many bytes will be used from each index row.
- D. It shows the total size of the index row.
正解: C
質問 87
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?
(Choose two.)
- A. to allow a backup to be created under reduced load
- B. to prevent schema changes from propagating to the slave before they are validated
- C. to prevent any transaction experiencing a deadlock
- D. to allow for point-in-time recovery on the slave
- E. to allow the remaining events to be processed on the slave while not receiving new events from the master
正解: A,D
質問 88
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> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'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> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
正解: C
質問 89
Which statement best describes the purpose of the InnoDB buffer pool?
- A. It is a pool of memory for SQL query sort operations from within the InnoDB engine.
- 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 holds changes made during a transaction before they are written to the log.
正解: D
質問 90
SQL injection is a common security threat.
Which two methods would help protect against this risk?
- A. using SQL variables to secure input values
- B. using stored procedures to validate values that are input
- C. installing the SQL Protection plugin to catch such attempts
- D. starting the server with the --injection-protection command-line option.
- E. using prepared statements to handle unsecured values
正解: A,B
質問 91
Consider the table people with this definition:
The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)
- A. Add FORCE INDEX (Birthday) to the query.
- B. Add a functional index for YEAR(Birthday).
- C. Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
- D. Add a generated column calculating YEAR(Birthday) and index that column.
- E. Execute ANALYZE TABLE to update the index statistics.
正解: A,C
質問 92
You want to immediately stop access to a database server for remote user
'mike'@'client.example.com'. This user is currently not connected to the server.
Which two actions can you take to stop any access from the user? (Choose two.)
- A. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;
- B. Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;
- C. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';
- D. Use DROP USER `mike'@'client.example.com';
- E. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;
- F. Execute the mysql_secure_installation command.
正解: B,D
質問 93
What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)
- A. Partitioned tables are not supported.
- B. It is the safest way to extract tables from the shared tablespace.
- C. The InnoDB Storage engine must be used for the table being exported.
- D. Table only exports when the table has its own tablespace.
- E. It can be used to export TEMPORARY tables.
正解: D,E
質問 94
Which two methods will provide the total number of partitions on a table? (Choose two.)
- A. Query the INFORMATION_SCHEMA.PARTITIONS table
- B. Query the INFORMATION_SCHEMA.TABLES table for the partition_count
- C. Query the performance_schema.objects_summary_global_by_type table
- D. Use the command: SHOW CREATE TABLE
- E. Use the command: SHOW TABLE STATUS
正解: A,E
解説:
https://dev.mysql.com/doc/refman/5.7/en/partitions-table.html https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
質問 95
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:
Which two options would help avoid the long wait in the future?
- A. Increase the value of the innodb_lock_wait_timeoutoption.
- B. Change the table to use HASH indexes instead of BTREE indexes.
- C. Set the value of innodb_adaptive_hash_indexto zero.
- D. Deactivate the query cache.
- E. Increase the value of the innodb_read_io_threadsoption.
- F. Increase the size of the InnoDB buffer pool.
正解: E,F
質問 96
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 system tablespace.
- B. it is the default location for all new tables that you create.
- C. it contains the redo log.
- D. it contains a general tablespace.
- E. it contains the undo log.
- F. it contains the binary log.
正解: A,B
解説:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
質問 97
A MySQL instance has this configuration values set:
A transaction involving a single InnoDB INSERTstatement commits.
Which list of locations is in the sequence of disk writes for this transaction?
- A. binary log, redo log, doublewrite buffer, and tablespace
- B. doublewrite buffer, redo log, tablespace, and binary log
- C. redo log, doublewrite buffer, tablespace, and binary log
- D. redo log, binary log, doublewrite buffer, and tablespace
正解: A
質問 98
A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:
What are two possible causes for this error to occur?
- A. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
- B. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
> /data/data.sql - C. The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.
- D. The applications have the SUPERprivilege, which allows them to update rows.
- E. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
正解: B,E
質問 99
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
- A. The mysql service has already been started on the same port.
- B. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
- C. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port 80, which is in use by the built-in web server.
- D. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
- E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.
正解: E
質問 100
The /myfolder/my.cnf file has option set:
[mysqld]
skip-log-bin
/myfolder2/my.cnf has this option set:
[mysqld]
log-bin = /valid/path/to/mysqlbinlog
All mentioned paths are accessible to the account that you are currently using. Assume that any other options mentioned in either file are valid and legal option definitions.
You start an instance by using this command line:
mysqld --defaults-file=/myfolder/my.cnf --defaults-extra-file=/myfolder2/my.cnf What is the outcome?
- A. MySQL fails to start due to the conflicting options in the configuration files.
- B. MySQL starts and Binary Logging is enabled.
- C. MySQL fails to start due to conflicting options on the command line.
- D. MySQL starts but Binary Logging is disabled.
正解: C
質問 101
You have installed the validate_password plug-in and set the validate_password_policy variable.
Which validation is affected by the validate_password_policy setting?
- A. whether a new password is rejected if it contains a word found in a dictionary file.
- B. the amount of delay after an incorrect password is entered
- C. whether a new password is rejected if it contains the current user's username.
- D. the length of time before a newly created password expires
正解: A
解説:
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
質問 102 
What does the possible_keyscolumn in this output denote?
- A. if there are any indexes that may be used to solve this query
- B. whether there are any indexes on the tables that you are querying
- C. if it is possible for you to include any indexes in your query
- D. whether there are any indexes in your query
正解: C
質問 103
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords. Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash?
- A. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY `iambatman';
- B. CREATE USER WITH sha256_password `sha256_user'@'192.0.2.10' IDENTIFIED AS `webdesign' USING `imbatman';
- C. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS `imbatman';
- D. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
`imbatman'; - E. CREATE USER `webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY `imbatman';
- F. CREATE USER `webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
`imbatman';
正解: A,C
解説:
Reference:
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
質問 104
......
あなたを必ず合格させる1Z1-888問題集PDF2022年最新のに更新された155問あります：https://jp.fast2test.com/1Z1-888-premium-file.html