Master the Oracle 1z0-888 Exam: Essential Study Tips and Strategies

one

one row and a next-key lock for supremum

one row and a gap-lock

five

It relies on the shared disk architecture being visible to both servers.

It is provided by means of IP-level disk replication.

It implements High Availability by using the .NET Connector’s load balancing capabilities.

It is a shared-nothing architecture.

it contains the binary log.

it contains a general tablespace.

it is the default location for all new tables that you create.

it contains the system tablespace.

it contains the redo log.

it contains the undo log.

Install the X509 plug-in on the server.

Set the X509 option in the [client] section of the MySQL server’s configuration file.

Restart the server with the --require-x509 option.

Distribute client digital certificates to the client computers being used to log in by the user accounts.

Provide users access to the server’s private key.

the PERFORMANCE_SCHEMA tables

the SHOW PROCESSLIST command

the INNODB Lock Monitor details

the SHOW STATUS command

the INFORMATION_SCHEMA tables

mysql --protocol=PLAIN –uroot –p –h dbhost.example.com

INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;

export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’

SET GLOBAL mysql_cleartext_passwords=1;

mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED AS sha256_user WITH sha256_password ‘imbatman’;

CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED BY ‘iambatman’;

CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED WITH sha256_password BY ‘imbatman’;

CREATE USER WITH sha256_password ‘sha256_user’@’192.0.2.10’ IDENTIFIED AS ‘webdesign’ USING ‘imbatman’;

CREATE USER ‘webdesign’@’192.0.2.10’ WITH mysql_native_password USING SHA265 BY ‘imbatman’;

CREATE USER ‘webdesign’@’192.0.2.10’ IDENTIFIED BY SHA265 AS ‘imbatman’;

Change the WHERE clause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.

Add a functional index for YEAR(Birthday).

Execute ANALYZE TABLE to update the index statistics.

Add a generated column calculating YEAR(Birthday) and index that column.

Add FORCE INDEX (Birthday) to the query.

when a slave receives a change from the master, it is processed first, and then recorded in the relay log.

It maintains a record of available master binary logs and the current executed log position.

It stores changes on the master, and relays them to the slave.

When a slave receives a change from the master, it is recorded in the relay log first and processed later.

Global variables are not persistent across server restarts.

Session variables are not persistent across server restarts.

The query benefited from sort_buffer_size increase.

sort_buffer_size should match tmp_table_size to be optimal.

The query benefited from tmp_table_size increase.

The query benefited from sort_buffer_size and tmp_table_size increases.