Free Oracle 1Z0-909 Practice Test & Real Exam Questions

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

Exam Questions: 66
Updated On: Oct 06, 2026

Question #8

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 doc->"$.name" FROM col WHERE doc->"$.season" = "1";

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

C. SELECT name FROM col WHERE season = 1;

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

Discussion 0

Correct Answer: B Vote an answer

Question #9

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

A. in an if statement

B. in a signal statement

C. in a while loop

D. in a leave statement to exit a loop

E. in a handler declaration

Discussion 0

Correct Answer: B,C Vote an answer

Question #10

Examine this statement and output:

What causes the error?

A. The database server process does not have sufficient privilege.

B. The set local_infile option has not been enabled.

C. The database client process does not have sufficient privilege.

D. The database server is running in read-only mode.

E. The database user does not have sufficient privilege.

F. The engine is disabled.

Discussion 0

Correct Answer: A Vote an answer

Question #11

Examine these statements and output:

Now, examine this command:
Mysql> ROLLBACK;
What is true about the effect of the command?

A. It returns an error because there is no active transaction.

B. It undoes the insert command.

C. It has no effect.

D. It undoes the update command.

E. It undoes both insert and update commands.

Discussion 0

Correct Answer: B Vote an answer

Question #12

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

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

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

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

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

Discussion 0

Correct Answer: D Vote an answer

Question #13

Which two are true about MySQL Document Store?

A. It depends heavily on strictly typed data.

B. It helps to store data items in a schema-less key-value store.

C. There is no access to relational tables.

D. It can store documents greater than 4 GB.

E. It allows one to bypass the SQL layer of the server.

Discussion 0

Correct Answer: B,E Vote an answer

Question #14

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

A. mysqli includes X DevAPI functions.

B. mysqli supports object oriented programming.

C. mysqli can access databases from other vendors.

D. mysqli supports non blocking, asynchronous queries.

Discussion 0

Correct Answer: B Vote an answer

Download Free Oracle 1Z0-909 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-909 exam.