Oracle 1Z0-909 Actual Free Exam Questions & Community Discussion

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: Jul 07, 2026

Question #15

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

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

C. The event is not scheduled and will no longer execute. The system will log an error.

D. The event is scheduled but will no longer execute. The system will log an error.

Discussion 0

Correct Answer: D Vote an answer

Question #16

Examine the statement which executes successfully:
SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ;
You try to create a table with a storage engine that is not available. What will happen?

A. The server will create the table but report an error when the first attempt to insert a row is performed.

B. The server will create the table using the default storage engine.

C. An error occurs and the create table statement fails.

D. The server will create the table but it will be unusable until the specified storage engine is available.

Discussion 0

Correct Answer: C Vote an answer

Question #17

Which select statement returns true?

A. SELECT NULL <> NULL;

B. SELECT NULL <=> NULL;

C. SELECT NULL = NULL;

D. SELECT NULL := NULL;

Discussion 0

Correct Answer: B Vote an answer

Question #18

Examine this statement which executes successfully:

The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output:

Why is an empty result set returned?

A. The virtual values in the name column must be accessed using functions.

B. Table statistics must be updated to generate values for the name column.

C. The json_extract() function requires a length value that matches the field length in the schema.

D. The select requires json_unquoteo in the where clause.

E. The JSON datatype cannot be used in virtual columns.

Discussion 0

Correct Answer: E Vote an answer

Question #19

Your session has sqi_mode set to default.
Examine this statement which executes successfully:

Now examine this statement:

Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date

A. Change date () to CURRENT_TIMESTAMP () .

B. Change " NULL " to ' NULL ' .

C. Change DATE () to DAY ().

D. Change "O'Hagen" to "O\'Hagen".

E. Change " NULL " to NULL.

F. Change "O'Hagen" to 'o\'Hagen'.

Discussion 0

Correct Answer: C,E Vote an answer

Question #20

Which two are true about MySQL Document Store?

A. There is no access to relational tables.

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

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

D. It depends heavily on strictly typed data.

E. It can store documents greater than 4 GB.

Discussion 0

Correct Answer: B,C Vote an answer

Question #21

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 not returned because the transaction still active in s2.

C. The inserted row is returned because the isolation level is RPEATABLE READ in S1.

D. The inserted row is returned because the transaction is auto committed in S2.

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.