Provide Oracle 1Z0-888 Practice Test Engine for Preparation [Q51-Q68]

Provide Oracle 1Z0-888 Practice Test Engine for Preparation

Detailed New 1Z0-888 Exam Questions for Concept Clearance

NEW QUESTION 51
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 are not affected by this configuration change.
• B. They will have to change their password the next time they login to the server.
• C. They will have their passwords updated on start-up to sha256_passwordformat.
• D. They all connect via the secure sha256_passwordalgorithm without any configuration change.

Answer: A

 

NEW QUESTION 52
You have created a new user with this statement:
CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE; What is the outcome?

• A. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
• B. 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.
• C. 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.
• D. 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.

Answer: B

 

NEW QUESTION 53
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 holds changes made during a transaction before they are written to the log.
• C. It caches only the indexes for InnoDB tables.
• D. It is amount of buffers available during a transaction.
• E. It caches data and indexes for InnoDB tables.

Answer: E

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

 

NEW QUESTION 54
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 GLOBAL SQL_SKIP_SLAVE_COUNTER=1
• B. SET GTID_NEXT="CONSISTENCY";
  BEGIN; COMMIT;
  SET GTID_NEXT="AUTOMATIC";
• C. SET GLOBAL enforce_gtid_consistency=ON
• D. SET GTID_NEXT="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";
  BEGIN; COMMIT;
  SET GTID_NEXT="AUTOMATIC";
• E. SET GTID_EXECUTED="5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8";

Answer: A

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

 

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

• A. The slave is configured with slave_parallel_workers = 4
• B. The salve has two intermediate relay slaves connected to it.
• C. THREAD_ID 21 has stopped running.
• D. The slave cannot process the relay log fast enough to use all threads.
• E. The server needs more cores to use all slave threads.
• F. At most, two schemas are being updates concurrently.

Answer: A,D

 

NEW QUESTION 56
Which three allocate memory per thread in MySQL? (Choose three.)

• A. read buffer
• B. InnoDB buffer pool instance
• C. internal temporary table
• D. sort buffer
• E. query cache
• F. thread cache

Answer: A,B,D

Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html

 

NEW QUESTION 57
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

• A. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
• B. sync_binlog=0 and the master server crashed.
• C. binlog_cache_size=1024 is too small and transactions are lost.
• D. The sync_relay_log=1000 setting on the slave is too small.
• E. binlog_format=STATEMENT and a non-deterministic query was executed.

Answer: A,C

 

NEW QUESTION 58
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. The slave is configured with slave_parallel_workers = 4
• B. THREAD_ID 21 has stopped running.
• C. The slave has two intermediate relay slaves connected to it.
• D. The slave cannot process the relay log fast enough to use all threads.
• E. The server needs more cores to use all slave threads.
• F. At most, two schemas are being updates concurrently.

Answer: A,D

 

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

Answer: A,C

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

 

NEW QUESTION 60
Which two methods will provide the total number of partitions on a table? (Choose two.)

• A. Query the INFORMATION_SCHEMA.PARTITIONS table
• B. Use the command: SHOW CREATE TABLE
• C. Query the performance_schema.objects_summary_global_by_type table
• D. Use the command: SHOW TABLE STATUS
• E. Query the INFORMATION_SCHEMA.TABLES table for the partition_count

Answer: A,D

Explanation:
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

 

NEW QUESTION 61
This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delayvariable to have a value of 360?

• A. The network latency between the master and the slave is 360 milliseconds.
• B. The slave was configured for delayed replication with a delay of six minutes.
• C. The master has performed a large transaction, which will take 360 seconds to complete on the slave.
• D. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

Answer: B

Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/show-slave-status.html

 

NEW QUESTION 62
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 datadirto the 'mysql' user?

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

Answer: C

 

NEW QUESTION 63
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

• A. Configure IPv6 network for hosts.
• B. Guarantee a secondary index on every table.
• C. Set isolation level to be READ COMMITTED.
• D. Use the binary log row format.
• E. Set multiple slave parallel worker threads.
• F. Set isolation level to be SERIALIZABLE.
• G. Guarantee a primary key on every table.

Answer: D,F,G

 

NEW QUESTION 64
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 mysqld 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. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• D. 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. 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.

Answer: D

 

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

• A. it contains a general tablespace.
• B. it contains the system tablespace.
• C. it contains the binary log.
• D. it is the default location for all new tables that you create.
• E. it contains the undo log.
• F. it contains the redo log.

Answer: B,D

 

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

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

Answer: C

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

 

NEW QUESTION 67
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. shell> mysqlimport test dump.sql
• C. shell> mysqladmin recover test dump.sql
• D. mysql>USE test; mysql>SOURCE dump.sql;
• E. mysql> USE test; mysql> LOAD DATA INFILE 'dump.sql';

Answer: B,E

 

NEW QUESTION 68
......

1Z0-888 2022 Training With 155 QA's: https://actualtests.vceengine.com/1Z0-888-vce-test-engine.html