최신 1Z0-909 무료덤프 - Oracle MySQL 8.0 Database Developer

문제1

Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?

A. Statements in Session 2 are committed.

B. Session 1 must commit before the update in Session 2 can complete.

C. Session 2 does not start a transaction.

D. Session 1 does not block Session 2.

E. Session 2 takes an exclusive lock on all the rows in the band table.

F. Session 1 takes a shared lock on all the rows in the band table.

정답: A,B

문제2

Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

A. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;

B. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

C. SELECT 'Car' RLIKE 'Ca?' INTO @r;

D. SELECT 'Car' LIKE 'Ca?' INTO @r;

정답: C

문제3

How does InnoDB choose deadlock victims in MySQL?

A. It chooses the transaction randomly.

B. It chooses the transaction with the most accumulated CPU time.

C. It chooses the transaction with the least accumulated CPU time.

D. It chooses the transaction with the lowest transaction ID.

E. It chooses the transaction with the most modified rows.

F. It chooses the transaction with the fewest modified rows.

정답: A

문제4

Examine this statement:

A. user who creates the procedure needing the create and execute privileges

B. user who creates the procedure needing the create routine privilege

C. inserting USE <database >; before line 3

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

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

정답: D

문제5

Examine this statement that execute successfully in an interactive session:

The user running this session now goes to lunch for an hour.
Now, examine these statements executed independently in separate sessions while Session 0 is still active:

How many of them will complete while Session 0 is still active?

A. 4

B. 1

C. 3

D. 0

E. 2

F. 5

정답: B

문제6

Which two statements are true about AUTO_INCREMENT?

A. A table can have multiple AUTO_INCREMENT columns.

B. The decimal data type supports AUTO_INCREMENT.

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

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

E. An AUTO_INCREMENT column must be indexed.

정답: D,E

문제7

Examine these statements issued from Session 1 which execute successfully:

Now, examine this statement issued from Session 2:

What is the outcome of the update statement in Session 2?

A. A deadlock will occur.

B. The row will be updated immediately.

C. The statement will wait for the transaction in Session 1 to finish.

D. The transaction in Session 1 will be rolled back automatically.

정답: D

최신 1Z0-909 무료덤프 - Oracle MySQL 8.0 Database Developer

우리와 연락하기

유용한 링크

최신 업데이트