Try Free Oracle 1Z0-888 Updated Questions & Answers

Question 1

You have created a new user with this statement:

CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE;

What is the outcome?

AWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.

BWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.

CWhen 'erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

DYou receive a syntax error that indicates that you cannot set a password and expire it at the same time.

Correct answer: A

Question 2

In which order does MySQL process an incoming INSERT statement?

AIt checks whether the user is authorized to perform the query, writes to the binary log, and then optimizes it.

BIt checks whether the user is authorized to perform the query, optimizes it, and then writes to the binary log.

CIt writes the query to the binary log, optimizes it, and then checks whether the user is authorized to perform the query.

DIt optimizes the query, checks whether the user is authorized to perform it, and then writes to the binary log.

Correct answer: C

Question 3

A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a 'SHOW CREATE TABLE mytable'' on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

ASET GTID_NEXT=''CONSISTENCY'';BEGIN; COMMIT;SET GTID_NEXT=''AUTOMATIC'';

BSETGTID_NEXT=''5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8'';BEGIN;COMMIT;SET GTID_NEXT=''AUTOMATIC'';

CSET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

DSET GLOBAL enforce_gtid_consistency=ON

ESET GTID_EXECUTED=''5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8'';
References:

Correct answer: C

Question 4

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

AInnoDB never uses table-level locks.

BInnoDB always protects auto-increment updates with a table-level lock

CInnoDB does not use locks to enforce auto-increment uniqueness.

DThe auto-increment lock can be a table-level lock.

ESome settings for innodb_autoinc_lock_mode can help reduce locking.

Correct answer: D, E

Question 5

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

Avalidate_password_policy cannot be set without restarting the MySQL instance.

BThe name of the dictionary file is too obvious.

CThe dictionary file word list is too short.

Dvalidate_password_dictionary_file cannot be set without restarting the MySQL instance.

EThe validate_password plug-in has not been loaded.

FThe dictionary file is in an insecure location.

Correct answer: B, F

1Z0-888 Exam Dumps and Practice Questions

Most Recent Oracle 1Z0-888 Exam Dumps

Actual Oracle 1Z0-888 Exam Questions

Unlock all Oracle 1Z0-888 questions