[Jul-2022] Pass Oracle 1Z0-888 Exam in First Attempt Guaranteed! [Q23-Q46]

Rate this post

[Jul-2022] Pass Oracle 1Z0-888 Exam in First Attempt Guaranteed!

Full 1Z0-888 Practice Test and 155 unique questions with explanations waiting just for you, get it now!

QUESTION 23
A general purpose MySQL instance is configured with the following options:
–slow-query-log
–long-query-time=.0001
–log-queries-not-using-indexes
–log-slow-admin-queries
–general-log
–log-bin
–binlog-format=STATEMENT
–innodb-flush-log-at-trx-commit=1
Which three statements are true for most workloads? (Choose three.)

The Slow Query Log records more data than the General Query Log.

The General Query Log records more data than the Slow Query Log.

The Slow Query Log records more data than the Binary Log.

The Binary Log records more data than the General Query Log.

The Binary Log records more data than the Slow Query Log.

The General Query Log records more data than the Binary Log.

QUESTION 24
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

log-master-updates

rpl-recovery-rank

server-id

enable-master-start

log_bin

master-logging

QUESTION 25
How does the InnoDB storage engine handle deadlocks when they are detected?

Both the affected transactions will be rolled back.

The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

One of the affected transactions will be rolled back, the other is allowed to proceed.

The transaction isolation level determines which transaction is rolled back.

The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

QUESTION 26
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.)

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-filepointing 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-insecureto force a password reset procedure on the command line.

QUESTION 27
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.

QUESTION 28
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

The host on the command line is not defined in the login path.

The mysqld instance has not been restarted after creating the login path.

There is no password defined in the login path.

The DNS is not configured correctly for slave1 host.

The .mylogin.cnf file is not readable.

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

Query the INFORMATION_SCHEMA.PARTITIONS table

Use the command: SHOW TABLE STATUS

Query the performance_schema.objects_summary_global_by_type table

Query the INFORMATION_SCHEMA.TABLES table for the partition_count

Use the command: SHOW CREATE TABLE

QUESTION 30
This output is from a SHOW SLAVE STATUS:

What would cause the SQL_Delay variable to have a value of 360?

The master has performed a large transaction, which will take 360 seconds to complete on the slave.

The network latency between the master and the slave is 360 milliseconds.

The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

The slave was configured for delayed replication with a delay of six minutes.

QUESTION 31
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

mysqldumpslow

mysqldump

mysqlaccess

mysqlshow

mysqlslow

QUESTION 32
An administrator installs MySQL to run under a mysqlOS account. The administrator decides to disable logins to the mysqlaccount by using /nologinor /bin/falseas the user’s shell setting.
Which statement is true?

The mysqluser needs a login and its home directory must be the base directory of the installation.

The OS needs to allow logging in as mysqlso that administrative tasks can be performed.

This prevents mysqldfrom starting when standard startup scripts are used.

This prevents creation of a command shell with the mysqlaccount, while allowing mysqldto run.

QUESTION 33
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.)

Execute the PURGE BINARY LOGS NOT USED command.

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

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

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

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

QUESTION 34
When you examine a new MySQL installation with default configuration, you find a file called ibdata1in 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.

QUESTION 35
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;

QUESTION 36
You are looking at these details:

Why does the message “Waiting for an event from Coordinator” show up on the slave_worker threads?

The Event Schedular is not enabled on the slave host.

The slave is waiting for an event to come into the relay log.

The slave thread is waiting for another event to finish in another slave thread.

The binary log on the master is not being updated.

QUESTION 37
Which two statements describe how InnoDB recovery works?

InnoDB handles most crash recoveries automatically.

InnoDB blocks some operations when innodb_force_recovery is set to greater than 0.

There will in general be lost committed transactions after a crash using the default settings.

It is required to enable binlog_gtid_simple_recovery to perform a crash recovery.

It is recommended to set innodb_force_recovery = 1 as part of normal operations.

It is always required to enable innodb_force_recovery to perform a crash recovery.

QUESTION 38
What is the best method for monitoring Group Replication conflict resolution?

the PERFORMANCE_SCHEMA tables

the SHOW PROCESSLIST command

the INNODB Lock Monitor details

the SHOW STATUS command

the INFORMATION_SCHEMA tables

QUESTION 39
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
(Choose two.)

to allow the remaining events to be processed on the slave while not receiving new events from the master

to allow a backup to be created under reduced load

to allow for point-in-time recovery on the slave

to prevent schema changes from propagating to the slave before they are validated

to prevent any transaction experiencing a deadlock

QUESTION 40
SQL injection is a common security threat.
Which two methods would help protect against this risk?

using stored procedures to validate values that are input

using SQL variables to secure input values

using prepared statements to handle unsecured values

installing the SQL Protection plugin to catch such attempts

starting the server with the –injection-protection command-line option.

QUESTION 41
Consider the index information for the dept_emptable in the employee’s schema:

Which two conclusions can be made based on the output of the query?

There are three indexes on the table.

There is a redundant index on the dept_nocolumn.

The secondary indexes are optimized for unique key look-ups.

The values on the emp_nocolumn must be unique.

The selectivity of the dept_nocolumn is the best of the indexed columns.

There is a redundant index on the emp_nocolumn.

QUESTION 42
There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackupcommand.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/,with extra instances having their own separate my.cnffile (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

QUESTION 43
What are two benefits of using the –tab option with mysqldump? (Choose two.)

The schema and data are automatically dumped to separate files.

It is possible to restore the data in parallel.

It can be used together with –all-databases.

It can be piped directly into a running server.

QUESTION 44
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

–skip-opt

–lock-all-tables

–create-apply-log

–single-transaction

–master-data

QUESTION 45
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?

shell> mysqladmin recover test dump.sql

shell> mysql test < dump.sql

shell> mysqlimport test dump.sql

mysql> USE test; mysql> LOAD DATA INFILE `dump.sql’;

mysql>USE test; mysql>SOURCE dump.sql;

QUESTION 46
What is the best method for monitoring Group Replication conflict resolution?

the PERFORMANCE_SCHEMA tables

the SHOW PROCESSLIST command

the INNODB Lock Monitor details

the SHOW STATUS command

the INFORMATION_SCHEMA tables