Winter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ex2p65

Exact2Pass Menu

Login / Register

Question # 4

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

A.

log_queries_not_using_indexes

B.

log__slow_admin_statements=1

C.

log_queries_not_using_indexes=ON

D.

log_throttle_queries_not_using_indexes=100

Full Access
Question # 5

Which select statement returns true?

A.

SELECT NULL <> NULL;

B.

SELECT NULL <=> NULL;

C.

SELECT NULL = NULL;

D.

SELECT NULL := NULL;

Full Access
Question # 6

Examine the layout of the my_values table.

Examine the data in the my_value3 table.

Examine this statement:

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 7

Examine the appointments table definition which contains one million rows:

Now, examine this statement which executes successfully:

Which statement will improve query performance?

A.

ALTER TABLE appointments add index IX_4

B.

ALTER TABLE appointments add index IX_1(credit,payment)

C.

ALTER TABLE appointments add index IX_2(attendant_session_id, created_by)

D.

ALTER TABLE appointments add index IX_3(attendant_id, created_by)

Full Access
Question # 8

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 # 9

Which change will prevent negative ages to be inserted into the people table?

A.

DELIMITER //

CREATE TRIGGER agecheck BEFORE INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN

SET NEW.age =0; END IF;//

DELIMITER ;

B.

ALTER TABLE people ADD COLUMN valid_age=ABS(check_age) GENERATED ALWAYS;

C.

DELIMITER //

CREATE TRIGGER age check AFTER INSERT ON people FOR EACH ROW IF NEW. age < 0 THEN

SET NEW.age =0; END IF;//

DELIMITER;

D.

ALTER TABLE people ADD CONSTRAINT check_age CHECK (ABS(age)>=0);

Full Access