Summer Goodies - 55% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: av5rz84q

Exact2Pass Menu

Question # 4

Examine this statement:

A.

Inserting COMMIT; SET @m :=: before line 4

B.

user who creates the procedure needing the create and execute privileges

C.

user who creates the procedure needing the create routine privilege

D.

inserting USE ; before line 3

E.

Inserting DEFINER 'username '@' localhost' clause into the CREATE PROCEDURE statement

Full Access
Question # 5

Examine this event's metadata:

Now examine this command:

DROP USER 'userl'e'localhost';

Which effect will the command have on the event?

A.

The event is scheduled and executed but fails. The system will log an error.

B.

The event is scheduled but will no longer execute. The system will log an error.

C.

The event will be dropped without an error or warning.

D.

The event is not scheduled and will no longer execute. The system will log an error.

Full Access
Question # 6

Your program which uses a MySQL connector receives this error:

Client does not support authentication protocol request by server

The account running the program uses caching_sha2_password.

Which two resolve this conflict?

A.

Disable TLS/SSL authentication.

B.

Place this in the root directory of your shell account:

[mysqld] require__secure_transport=OFF

C.

Use blank RSA or SSL certificates.

D.

Upgrade the connector to a version that supports caching_sha2_password.

E.

Change the user account to use mysql_native_password.

Full Access
Question # 7

Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2:

Now, examine this statement that execute successfully in s1:

S1> SELECT * FROM emp;

Which is true about the result of the select statement?

A.

The inserted row is returned because the transaction is auto committed in S2.

B.

The inserted row is not returned because the isolation level is READ COMMITTED in S2.

C.

The inserted row is not returned because the transaction still active in s2.

D.

The inserted row is returned because the isolation level is RPEATABLE READ in S1.

Full Access
Question # 8

Which two statements are true about AUTO_INCREMENT?

A.

AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.

B.

A table can have multiple AUTO_INCREMENT columns.

C.

A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.

D.

The decimal data type supports AUTO_INCREMENT.

E.

An AUTO_INCREMENT column must be indexed.

Full Access
Question # 9

The continent column in the country table contains no null values.

Examine this output:

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access