Online Access Free Oracle.1Z1-888.v2022-02-09.q146 Practice Test (Page 20)

1Z1-888 Exam Question 91

You want to create a temporary table named OLD_INVENTORYin the OLD_INVENTORYdatabase on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

A.Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

B.Use the --replicate-ignore-tableoption with the value equal to
OLD_INVENTORY.OLD_INVENTORYand restart mysqldbefore creating the temporary table.

C.Set binlog_format=MIXED with the --replicate-ignore-temp-table option.

D.Change the binlog_formatoption to ROW and restart mysqld before you create the OLD_INVENTORYtable.

E.Stop SQL_THREADon the slave until you have finished using the OLD_INVENTORYtemporary table.

1Z1-888 Exam Question 92

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

A.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH

B.sha256_password 'imbatman';
CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';

C.CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY

D.'imbatman';
CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS

E.'webdesign' USING 'imbatman';
CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY

F.'imbatman';
CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';

1Z1-888 Exam Question 93

Consider these global status variables:

Which two conclusions can be made from the output?

A.All max_connections were in use at 2018-03-22 14:54:06

B.The thread cache has been configured with thread_cache_size set to at least 6.

C.There are 140 Performance Schema threads at the time of the output.

D.There are 510 connections to MySQL at the time of the output.

E.There are more connections being idle than executing queries.

1Z1-888 Exam Question 94

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 in --safe-mode, which only loads the privilege system for changes as data is inaccessible.

B.Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.

C.Start the MySQL Server with --init-filepointing to SQL that executes an ALTER USER statement to change the root user password.

D.Start the MySQL Server with --skip-grant-tables and execute SQL, which will update the root password.

E.Start the MySQL Server with -initialize-insecureto force a password reset procedure on the command line.

1Z1-888 Exam Question 95

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.Execute the PURGE BINARY LOGS NOT USED command.

B.Edit the .index file to remove the files you want to delete.

C.Ensure that none of the attached slaves are using any of the binary logs you want to delete.

D.Remove all of the binary log files that have a modification date earlier than today.

E.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

Other Version: 44Oracle.Newpassleader.1Z1-888.v2022-03-24.by.larry.146q.pdf

Latest Upload: 101SAP.C_ABAPD_2507.v2025-09-12.q56; 101SAP.C_TS452_2022.v2025-09-12.q83; 171ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 136SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 136SAP.C_SIGPM_2403.v2025-09-08.q20

1Z1-888 Exam Question 91

1Z1-888 Exam Question 92

1Z1-888 Exam Question 93

1Z1-888 Exam Question 94

1Z1-888 Exam Question 95

Download PDF File