[Dec-2022] Use Real 1Z0-888 Dumps Free Sample Questions and Practice Test Engine [Q91-Q110]

4.3/5 - (3 votes)

[Dec-2022] Use Real 1Z0-888 Dumps Free Sample Questions and Practice Test Engine

Pass Oracle 1Z0-888 exam – questions – convert Tets Engine to PDF

NO.91 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?

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.

NO.92 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?

Start the MySQL Server in –safe-mode, which only loads the privilege system for changes as data is inaccessible.

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

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

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

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

NO.93 A crucial database, ‘db_prod’, just disappeared from your production MySQL instance.
In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’
Which three methods could have been used to prevent this SQL injection attack from happening?

writing your client code to properly escape all user input

giving limited privileges to accounts used by application servers to interact with their backing databases

using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions

using a hashing or encryption method to secure all user passwords in your MySQL tables

removing any remaining anonymous accounts from your MySQL instance

validating all user input before sending it to the database server

changing all passwords for the MySQL account ‘root’@’%’immediately after losing an employee who knew the current password

NO.94 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?

The mysqld service has already been started on the same port.

The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.

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.

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.

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.

NO.95 Which two statements are true regarding the creating of new MySQL physical and logical backups? (Choose two.)

Physical backups can be used to recover from data corruption.

Logical backups are human-readable whereas physical backups are not.

Logical backups are always larger than physical backups.

Physical backups are usually slower than text backups.

Physical backups are usually faster than text backups.

NO.96 The MySQL installation includes the mysql_config_editorutility for managing login paths stored in a
.mylogin.cnffile.
Which two are true about the login path feature? (Choose two.)

mysql_config_editoris the only MySQL-provided utility that can print the values stored in
.mylogin.cnf.

A .mylogin.cnffile can store at most one login path.

It provides a FIPS-compliant keyring for storing MySQL login details.

A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

It is an alternative to storing the MySQL login details in a my.cnffile.

It provides means to help avoid accidentally exposing the MySQL login details.

NO.97 Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?

executing REVOKE LOAD FROM *.*

setting the –local-service=0option when starting mysqld

executing REVOKE FILE FROM *_*

executing REVOKE FILE ON *_* FROM ‘ ‘@’%’

setting the –local-infile=0option when starting mysqld

setting the –open-files-limit=0option when starting mysqld

NO.98

What does the possible_keyscolumn in this output denote?

if it is possible for you to include any indexes in your query

whether there are any indexes on the tables that you are querying

if there are any indexes that may be used to solve this query

whether you are using any indexes in your query

NO.99 There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.
A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup. Which command-line option is required to successfully update the second instance?

–restore=2

–copy-back-from-log

–backup-instance=/var/lib/mysql/instance2

–instance=/var/lib/mysql/instance2

–defaults-file=/etc/mysql/instance2.cnf

NO.100 There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup –backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

–restore=2

–copy-back-from-log

–backup-instance=/var/lib/mysql/instance2

–instance=/var/lib/mysql/instance2

–defaults-file=/etc/mysql/instance2.cnf

NO.101 Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

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

NO.102 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?

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’;

NO.103 After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

Date should be a TIMESTAMP field for better performance.

The User field is too long for most names.

The engine type is not appropriate to the application use.

Using default values for DATETIME causes table scans.

No indexes are defined.

NO.104 An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

Bob has max_user_connections set to zero, which blocks all his connections.

All users are blocked because max_user_connections is accumulated over the host account information.

connect_timeout is too small to allow a connection to occur.

Joe has exceeded the max_user_connections global limit.

Kay is already connected elsewhere and attempting to log in again.

NO.105 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 STATUSindicates these values:
RELAY_LOG_FILE=hostname-relay-bin.00004

RELAY_LOG_POS=1383

Which command set would make the slave current?

STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname- relay-bin.00004’, RELAY_LOG_POS = 1383;

NO.106 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?

The salve has two intermediate relay slaves connected to it.

The slave is configured with slave_parallel_workers = 4

At most, two schemas are being updates concurrently.

THREAD_ID 21 has stopped running.

The slave cannot process the relay log fast enough to use all threads.

The server needs more cores to use all slave threads.

NO.107 A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)

enabling and using SSL for connections to the MySQL database

running the server with –skip-networking specified

disabling connections from named pipes or socket files (depending on the operating system of the server)

starting the server with –bind-address=0.0.0.0 specified

limiting logins to originate from the application server or the server’s subnet

installing MySQL on the application server, and running the database and application on the same server

NO.108 Which two methods accurately monitor the size of your total database size over time? (Choose two.)

monitoring the Innodb_rows_inserted status variable

monitoring the innodb_redo_log_size variable

monitoring the information_schema.TABLES table

monitoring datadir size in the operating system

monitoring cumulative Innodb_page_size increase

monitoring the performance_schema_hosts_size variable

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

binlog_format=STATEMENT

log-bin

apply-log

bonlog_format=ROW

gtid_enable

NO.110 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?

They are not affected by this configuration change.

They all connect via the secure sha256_password algorithm without any configuration change.

They will have their passwords updated on start-up to sha256_password format.

They will have to change their password the next time they login to the server.

Pass Your 1Z0-888 Exam Easily – Real 1Z0-888 Practice Dump Updated Dec 18, 2022: https://www.actualcollection.com/1Z0-888-exam-questions.html

Leave a comment Cancel reply