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 #29

Examine this statement which executes successfully:
CREATE TABLE 'fshop' ('product' JSON DEFAULT NULL ) ENGINE=InnoDB;
Now, examine a json value contained in the table:
{"name" : "orange", "varieties" : [{"VarietyName":"Clementine", "Origin" : ["PA", "BU"] }, {"VarietyName": "tangerine", "Origin" : ["CH","JP"]>]> Which will cause documents to be indexed over the 'name' key?

A. ALTER TABLE fshop ADD COLUMN name VARCHAR(20), ADD KEY idx_name (name) ;

B. ALTER TABLE fshop ADD name VARCHAR(20) AS (JSON_ONQUOTE (product->"S.varieties.VarietyName")), ADD INDEX (name);

C. ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product->' S - name' ) VIRTUAL, ADD KEY idx_name (name) ;

D. ALTER TABLE fshop ADD COLUMN name VARCHAR(20) AS (product-
>* S .varieties. VarietyName ' ) VIRTUAL, ADD KEY idx_name (name.) ;

E. ALTER TABLE fshop ADD COLUMN name VARCHAR(100) AS (product->' S - varieties' ) VIRTUAL, ADD KEY idx_name (name) ;

Discussion 0

Correct Answer: E Vote an answer

Question #30

Examine these statement which execute successfully:

Now, examine this desired output:

Which two queries will produce the out?

Discussion 0

Correct Answer: D,E Vote an answer

Question #31

Examine the content of the employee table:

Now examine this PHP script:

Finally examine this desired output:

A. $options = [PDO:: ATTR_DEFAOLT_FETCH__MODE => PDO : : FETCH_BOTH] ;

B. $options = [PDO:: ATTR_DEFAUXT_FETCH__MODE => PDO: : PDO: :FETCH_OBJ] ;

C. $options = [PDO:: ATTR__DEFAULT_FETCH MODE => PDO: :FETCH_CLASS] ;

D. $options = [PDO:: ATTR_DEFAULT_FETCH__MODE => PDO: : FETCH_ASSOC] ;

Discussion 0

Correct Answer: A Vote an answer

Question #32

Examine this statement and output:

Which is true?

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

B. myview cannot be automatically indexed.

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

D. myview was defined with the temptable processing algorithm.

Discussion 0

Correct Answer: D Vote an answer

Question #33

Examine these statements:
SET collation_connection=utf8mb4_0900_as_cs;
SELECT STRCMPCAlice', UCASE ('Alice* )) ;
What is displayed?

A. 0

B. NULL

C. -1

D. 1

E. ERROR: 1267 (HYOOO): Illegal mix of collations

Discussion 0

Correct Answer: C Vote an answer

Question #34

Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?

A. The trigger activates after any row has been inserted into the table.

B. Execution of an insert statement causes the trigger to activate.

C. The trigger activates after any row in the table has been updated.

D. The trigger body set causes trigger activation.

Discussion 0

Correct Answer: B Vote an answer

Question #35

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

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

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

Discussion 0

Correct Answer: D 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.