Free Oracle 1z0-888 Practice Exam with Questions & Answers | Set: 3

Name: How to Pass 1z0-888 Exams
Brand: Examstrack
SKU: 1z0-888
Price: 42 USD
Availability: InStock

Questions 21

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 datadir to the ‘mysql’ user?

Options:

MySQL needs to be run as the root user, but files cannot be owned by it.

The mysqld process requires all permissions within datadir to be the same.

MySQL cannot be run as the root user.

MySQL requires correct file ownership while remaining secure.

Oracle 1z0-888 Premium Access

Neil

02-Jan-2025

I couldn't have passed 1z0-888 without examstrack.com's verified questions and answers. Thank you!

Questions 22

Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?

Options:

The server will crash.

The server suspends that INSERT operation until space becomes available.

An error message will be returned to the client .Server Error: ER_IO

The server suspends operations for all storage engines until space becomes available.

Questions 23

You want to dump only data from the userdata table.

Which mysqldump command argument is required to accomplish this?

Options:

- -no-create-info to skip writing CREATE TABLE statements

- -single-transaction as this obtains a consistent view of data only

- -data-only as this specifies that only data is to be dumped

- -table=userdata in order to dump only the data from the userdata table

Questions 24

Where does MySQL Linux RPM install the mysqld binary?

Options:

/usr/libexec/

/usr/local/mysql/bin/

/usr/sbin/

/usr/bin/

/opt/mysql/server/bin/

Questions 25

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

Options:

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.

Questions 26

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.

The requirements for the backup are:

It must be possible to rebuild the instance using the backup.
It must be verified.
It must allow for a catastrophic hardware failure.

Which four steps must be included in the backup strategy? (Choose four.)

Options:

Include the keyring data and/or configuration in the backup.

Restore the backup to a clean MySQL instance.

Copy the backup to a remote host.

Include the MySQL socket file in the backup.

Include the ibtmp1 file in the backup.

Include the relay logs in the backup.

Include the operating system disk encryption key in the backup.

Questions 27

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

Options:

Set isolation level to be SERIALIZABLE.

Use the binary log row format.

Set isolation level to be READ COMMITTED.

Configure IPv6 network for hosts.

Guarantee a secondary index on every table.

Guarantee a primary key on every table.

Set multiple slave parallel worker threads.

Questions 28

A MySQL replication slave is set up as follows:

Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option

The replication slave has been found in an error state.

You check the MySQL error log file and find these entries:

1z0-888 Question 28

What are two possible causes for this error to occur? (Choose two.)

Options:

The applications have the SUPER privilege, which allows them to update rows.

The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.

The slave was created with mysqldump –u root –p --skip-lock-tables –all-databases > /data/data.sql

The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

Questions 29

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

Which 2 things should you investigate?

Options:

Check the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

Check the difference between the InnoDB status values “Log Sequence number” and “Last Checkpoint” positions then compare that to the total size of the redo log.

Check the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

Check the difference between the InooDB status values “Trx id counter” and “Purge done for” and compare to the state substatus of the main “Main thread”

Check the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Questions 30

Consider the index information for the dept_emp table in the employee’s schema:

1z0-888 Question 30