2022 Valid 1Z0-888 Exam Updates - 2022 Study Guide [Q43-Q65]

2022 Valid 1Z0-888 Exam Updates - 2022 Study Guide

1Z0-888 Certification - The Ultimate Guide [Updated 2022]

Exam Content

The examination consists of 75 Questions. Candidates should score 58% to clear the examination.

Formats of Question

Multiple Response Multiple-choice questions: Two or More Correct response from the given options best suits the statement or answers the question.
Single Response Multiple-choice questions: Only One correct response from the given options best suits the statement or answers the question.

Exam Duration

Candidates will have 120 minutes for attempting 75 questions. So, it becomes important for the candidates to time-box the exam and restrict spending too much time on one question or one topic.

Exam Results

The Oracle 1z0-888 certification is a pass or fail examination and the candidate has to score a minimum of 58% to be termed as pass in the certification exam.

Candidates will receive an email with the result from Oracle within 30 minutes of completing the Certification exam. Exam results are also available on the CertView web portal and the candidate can visit the portal and login to the CertView account to view the exam results and get further details.

NEW QUESTION 43
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

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.

Answer: C,E

NEW QUESTION 44
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 with --skip-grant-tables and execute SQL, which will update the root password.
B. Start the MySQL Server with --init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
C. Start the MySQL Server with -initialize-insecure to force a password reset procedure on the command line.
D. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
E. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

Answer: A,B

NEW QUESTION 45
Which MySQL utility copies the master instance to a slave instance on the same host?

A. mysqlserverclone
B. mysqlfailover
C. mysqlrplsync
D. mysqldbcopy

Answer: A

NEW QUESTION 46
While attempting to set up a new replication slave on host '192.168.0.25' with the user 'replication', you encounter this error:

What should you do to resolve this error?

A. Edit the my.ini file on the slave so that the master-host variable is equal to the IP address of the master, and restart the slave.
B. Add the user [email protected] with the correct password to the master.
C. Edit the DNS table on the master to include the domain name for the IP address of 192.168.0.25.
D. Add the user [email protected] with the correct password to the slave.

Answer: B

NEW QUESTION 47
You created a backup of the world database with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql?

A. shell> mysql test < dump.sql
B. mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';
C. shell> mysqladmin recover test dump.sql
D. mysql>USE test; mysql>SOURCE dump.sql;
E. shell> mysqlimport test dump.sql

Answer: B,E

NEW QUESTION 48
Multiversion Concurrency Control (MVCC) enables what type of backup?

A. Hot
B. Logical
C. Incremental
D. Binary

Answer: A

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/glossary.html

NEW QUESTION 49
Which three options are most likely to be changed for production form their default values? (Choose three.)

A. max_connections
B. character_set_system
C. innodb_log_file_size
D. innodb_buffer_pool_size
E. max_user_connections
F. join_buffer_size
G. port

Answer: C,E,G

NEW QUESTION 50
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 WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS
'webdesign' USING 'imbatman';
B. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY
'imbatman';
C. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';
D. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
'imbatman';
E. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH
sha256_password 'imbatman';

Answer: C,E

Explanation:
Reference: https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

NEW QUESTION 51
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

A. apply-log
B. gtid_enable
C. binlog_format=STATEMENT
D. log-bin
E. bonlog_format=ROW

Answer: D

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time-recovery.html

NEW QUESTION 52
You created a backup of the worlddatabase with this command:
shell> mysqldump --opt world > dump.sql
Which two will import the data from dump.sql? (Choose two.)

A. shell> mysql test < dump.sql
B. mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';
C. shell> mysqladmin recover test dump.sql
D. mysql>USE test; mysql>SOURCE dump.sql;
E. shell> mysqlimport test dump.sql

Answer: B,E

NEW QUESTION 53
Which two statements are true about InnoDB auto-increment locking? (Choose two.)

A. InnoDB always protects auto-increment updates with a table-level lock
B. InnoDB never uses table_level locks.
C. InnoDB does not use locks to enforce auto-increment uniqueness.
D. The auto-increment lock can be a table-level lock.
E. Some settings for innodb_autoinc_lock_mode can help reduce locking.

Answer: D,E

NEW QUESTION 54
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-databases does not include it.
B. Use the -grants option to include GRANT statements in the dump.
C. Use the -flush-privileges with mysqldump.
D. After the restore, log in to the database and execute FLUSH PRIVILEGES.

Answer: A

NEW QUESTION 55
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.

Answer: A

NEW QUESTION 56
Recently, users on mostly-write MySQL database have been complaining of slowdowns or stalls in their applications.
Which option is most likely to have a positive effect on the server's health and performance?

A. Increase the size of redo logs.
B. Move redo logs to /dev/shm to improve their speed.
C. Lower innodb_max_dirty_pages_pct to flush more often.
D. Reduce the size of redo logs to improve storage efficiency.

Answer: C

NEW QUESTION 57
Exhibit:

What does the possible_keys column in this output denote?

A. whether there are 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

Answer: B

NEW QUESTION 58
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 GLOBAL SQL_SKIP_SLAVE_COUNTER=1
D. SET GLOBAL enforce_gtid_consistency=ON
E. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";

Answer: C

Explanation:
Reference: https://dev.mysql.com/doc/refman/8.0/en/replication-problems.html

NEW QUESTION 59
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

A. The log_bin variable is set to OFF on the slave.
B. server_id is not unique.
C. The max_connections variable on the slave needs to be increased.
D. The shared_memory_base_name variable must match the master.
E. The version of the slave is newer that the version of the master.

Answer: A

NEW QUESTION 60
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? (Choose two.)

A. Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.
B. Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.
C. Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.
D. Start the MySQL Server in --safe-mode, which only loads the privilege system for changes as data is inaccessible.
E. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

Answer: A,B

Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html

NEW QUESTION 61
MySQL is installed on a Linux server and has this configuration:
[mysqld]
user=mysql
datadir=/data/mysql/
As the 'root' user, you change the datadir location by executing:
shell> cp -R /var/lib/mysql /data/mysql/
shell> chown -R mysql /data/mysql
What is the purpose of changing ownership of datadir to the 'mysql' user?

A. MySQL requires correct file ownership while remaining secure.
B. MySQL needs to be run as the root user, but files cannot be owned by it.
C. MySQL cannot be run as the root user.
D. The mysqld process requires all permissions within datadir to be the same.

Answer: B

NEW QUESTION 62
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is 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 21 has stopped running.
B. The slave is configured with slave_parallel_workers = 4
C. At most, two schemas are being updates concurrently.
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.

Answer: B,E

NEW QUESTION 63
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. innodb_flush_method=O_DIRECT
B. query_cache_size = 2G
query_cache_enabled=1
C. sync_binlog=10
D. innodb_buffer_pool_instances=64
innodb_buffer_pool_size=200G
E. max_heap_table_size = 2G
tmp_table_size=2G
F. innodb_flush_log_at_trx_commit=0
G. log_bin=mysql -bin
Innodb_flush_log_at_trx_commit=1
H. table_open_cache = 64

Answer: A,B,D,H

NEW QUESTION 64
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 STATUS indicates 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; SET GLOBAL master_delay=0; START SLAVE;
C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE =
'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
D. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE =
'hostname-relay-bin.00004',RELAY_LOG_POS = 1383;

Answer: A

NEW QUESTION 65
......