Free 1z1-909 Questions for Oracle MySQL 8.0 Database Developer 1z1-909 Exam as PDF & Practice Test Engine

Exam Code/Number: 1z1-909
Exam Name/Title: MySQL 8.0 Database Developer
Certification Provider: Oracle
Corresponding Certification: MySQL Developer

Exam Questions: 66
Updated On: May 27, 2026

Question #1

A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?

A. The socket is not implemented in Connector/J driver.

B. Java treats the socket file as insecure.

C. The X Dev API protocol must be enabled to use sockets in Connector/J driver.

D. The socket can only be accessed from the local host.

E. socket is a reserved word in Java.

Discussion 0

Correct Answer: A,B Vote an answer

Question #2

The meeting table stores meeting schedules with participants from five continents. The participants' details are stored in another table.

You need to adjust the start_time and duration columns for optimal storage. What datatype changes would achieve this?

A. start_time TIMESTAMP duration TIME

B. start_time DATETIME duration DATETIME

C. start_time TIMESTAMP duration TIMESTAMP

D. start__time DATETIME duration TIME

E. start_time TIME duration TIME

Discussion 0

Correct Answer: B Vote an answer

Question #3

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 supports object oriented programming.

C. mysqli includes X DevAPI functions.

D. mysqli supports non blocking, asynchronous queries.

Discussion 0

Correct Answer: B Vote an answer

Question #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 last_name, ' , ',first_name FROM employees;

B. SELECT GROUP_CONCAT(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;

Discussion 0

Correct Answer: C,E Vote an answer

Question #5

The collection col contains all episodes for all seasons for a TV show.
Examine this document which has an example of the details for each episode:

Which query returns all expisode names from the first season?

A. SELECT name FROM col WHERE season = 1;

B. SELECT "S.name" FROM col WHERE "S.season" = "1";

C. SELECT doc->,,$.name,, FROM col WHERE doc->"$ . season" = "1";

D. SELECT doc->"$.name" FROM col WHERE doc->"$.season" = "1";

Discussion 0

Correct Answer: B Vote an answer

Question #6

How does InnoDB choose deadlock victims in MySQL?

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

B. It chooses the transaction randomly.

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

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

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

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

Discussion 0

Correct Answer: B Vote an answer

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 an if statement

C. in a signal statement

D. in a while loop

E. in a leave statement to exit a loop

Discussion 0

Correct Answer: C,D Vote an answer

Free 1z1-909 Questions for Oracle MySQL 8.0 Database Developer 1z1-909 Exam as PDF & Practice Test Engine

Download Free Oracle 1z1-909 Demo