MySQL 8.0 Database Developer (1z1-909) Free Practice Test

Question 1

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

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

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

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

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

Correct Answer: C

Question 2

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 statement will wait for the transaction in Session 1 to finish.

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

D. The row will be updated immediately.

Correct Answer: C

Question 3

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 not scheduled and will no longer execute. 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 is scheduled and executed but fails. The system will log an error.

D. The event will be dropped without an error or warning.

Correct Answer: B

Question 4

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

A. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

B. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

C. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

D. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

E. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

Correct Answer: D,E

Question 5

Examine this statement and output:

Now, examine these desired output values:

Which statement updates the table data as require

A. UPDATE exam_result SET score=TRUNCATE

B. UPDATE examresult SET score=ROUND(CEIL(score

C. UPDATE exam_result SET score=CEIL(ROUND(score,1));

D. UPDATE exam_result SET score=TRUNCATE(score,1);

E. UPDATE exam_result SET score=CEIL(TRUNCATE(sco

F. UPDATE exam_result SET score=ROUND(score,1);

Correct Answer: F

Question 6

What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?

A. mysqli can access databases from other vendors.

B. mysqli includes X DevAPI functions.

C. mysqli supports object oriented programming.

D. mysqli supports non blocking, asynchronous queries.

Correct Answer: C

Question 7

Examine this statement:
DECLARE not_found CONDITION FOR SQLSTATE '02000';
In which two statements can not found be used?

A. in a handler declaration

B. in a leave statement to exit a loop

C. in a signal statement

D. in an if statement

E. in a while loop

Correct Answer: C,E

Welcome to TestSimulate

Oracle MySQL 8.0 Database Developer (1z1-909) Free Practice Test