Pass Oracle 1z0-888 Exam with 100% Passing Assurance | Realexamdumps.com

 Question #:1

What is the order of tables shown in an EXPLAIN output?

A. It lists tables from the smallest to the largest.

B. It lists tables in the order in which their data will be read.

C. It lists tables from the most optimized to the least optimized.

D. It lists tables in the order in which they are specified in the statement that is being explained.

Answer: D

Explanation

References:

Question #:2

Which statement is true about tablespaces?

A. All tablespace files must be in the directory specified by the –-datadir option.

B. General tablespaces can be configured to span multiple files.

C. All tables must be in either the system tablespace or a general tablespace.

D. The system tablespace can be configured to span multiple files.

Answer: C

Explanation

References:

Question #:3

You have installed the validate_password plug-in and set the validate_password_policy variable.

Which validation is affected by the validate_password_policy setting?

A. whether a new password is rejected if it contains a word found in a dictionary file.

B. whether a new password is rejected if it contains the current user’s username.

C. the amount of delay after an incorrect password is entered

D. the length of time before a newly created password expires

Answer: A


Explanation


References:


Question #:4




You need to dump the data from the master server and import it into a new slave server.

Which mysqldump option can be used when dumping data from the master server in order to include the

master server’s binary log information?

A. include-log-file

B master-binlog

C include-master-info

D. master-data

Answer: D

Question #:5

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

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

B Restore the backup to a clean MySQL instance.

C. Copy the backup to a remote host.

D. Include the MySQL socket file in the backup.

E.Include the ibtmp1 file in the backup.

F. Include the relay logs in the backup.

G. Include the operating system disk encryption key in the backup.

H. vInclude the MySQL PID file in the backup.

I. Include the binary logs in the backup.

Answer: C F G H