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

Question 1

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

A. Additional queries on the same session are blocked until the result set is released.

B. Large results can have a negative impact on performance.

C. Buffered queries are enabled by default.

D. Results are sent to the calling PHP process for buffering.

E. Buffered queries should be used on large tables when the result size is unknown.

F. Buffered queries must be explicitly enabled using mysqliuseresult.

G. Results are sent from the server to the browser for buffering.

Correct Answer: B,E,F

Question 2

Which two statements are true about AUTO_INCREMENT?

A. An AUTO_INCREMENT column must be indexed.

B. The decimal data type supports AUTO_INCREMENT.

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

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

E. A table can have multiple AUTO_INCREMENT columns.

Correct Answer: A,C

Question 3

Examine these commands and output:

Which is true about the execution of the insert statement?

A. It inserts a new row in the view only.

B. It inserts a new row in the base table only.

C. It inserts a row in the view and base table.

D. It returns an error.

Correct Answer: A

Question 4

Examine this statement and output:

Which will provide the same level of detail when the error is encountered within a stored routine?

A.

B.

C.

D.

Correct Answer: C

Question 5

Examine this statement and output:

Which is true?

A. myview cannot be automatically indexed.

B. Column Name in myview can be indexed if the is_updatable attribute is true.

C. myview was defined with the temptable processing algorithm.

D. The underlying table's index on the Name column is not chosen because of low selectivity.

Correct Answer: C

Question 6

The employee table includes these columns:
e_id INT, e_name VARCHAR (45), dept_id INT salart INT
You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.
Which statement will create the function?

A.