Oracle MySQL 8.0 Database Developer - 1z1-909 Exam Questions [2026]

QUESTION NO: 1
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_throttle_queries_not_using_indexes=100 C. log__slow_admin_statements=1 D. log_queries_not_using_indexes=ON

Correct Answer: C

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

A. Large results can have a negative impact on performance. B. Results are sent to the calling PHP process for buffering. C. Buffered queries are enabled by default. D. Additional queries on the same session are blocked until the result set is released. E. Buffered queries should be used on large tables when the result size is unknown. F. Results are sent from the server to the browser for buffering. G. Buffered queries must be explicitly enabled using mysqliuseresult.

Correct Answer: A,E,G

QUESTION NO: 3
Which two differences exist between the timestamp and date time data types?

A. timestamp has larger range of values. B. timestamp uses less storage space. C. timestamp stores the interval between two dates. D. timestamp converts the value based on the session time zone. E. timestamp stores more decimal points in seconds

Correct Answer: B,D

QUESTION NO: 4
You must write a statement that combines the first_name and last_name columns from the employees table as "last_name, first_name." Which two statements will do this?

A. SELECT GROUP_CONCAT(last_name, first_name) FROM employees; B. SELECT last_name + ', ' + first_name FROM employees; C. SELECT CONCAT(last name,', ',first_name) FROM employees; D. SELECT last_name, ' , ',first_name FROM employees; E. SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;

Correct Answer: C,E

QUESTION NO: 5
Which two are true about MySQL connectors?

A. Connector/ODBC is available on Unix, Windows, and MacOS X. B. Connectors must be installed on both the client and server hosts. C. Connector/J is based on Connector/C. D. Connector/NET runs on the Windows platform only. E. Connector/Python is released in precompiled binary and source code.

Correct Answer: B,C

QUESTION NO: 6
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 not returned because the isolation level is READ COMMITTED in S2. B. The inserted row is returned because the transaction is auto 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.

Correct Answer: C

QUESTION NO: 7
Examine this statement and output:

You execute this statement:
SELECT JSON_SEARCH(product,'one','IT') FROM fshop ;
What is the output?

A. product->''$.varieties [4]. origin[1];; B. ''$.varieties[4]. origin[1]'' C. ''$.varieties [3]. origin[0]'' D. product->varieties[3]. origin[0]''

Correct Answer: A