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

Examine this bar graph based on columns from the players table:

Which two statements would generate this bar graph?

A. SELECT Name, Gender, Sport, CONCAT ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

B. SELECT Name, Gender, Sport, CHAR_LENGTH ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

C. SELECT Name, Gender, Sport, RPAD ('# ' GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

D. SELECT Name, Gender, Sport, REPEAT('# 'Y GPA*10) AS GPA_Graph FROM players ORDER BY GPA DESC;

E. SELECT Name, Gender, Sport, LENGTH (GPA*10, '# ') AS GPA_Graph FROM players ORDER BY GPA DESC;

Discussion 0

Correct Answer: C,D Vote an answer

Question #2

Examine these statements issued from Session 1 which execute successfully:

Now, examine these statements issued from Session 2 which execute successfully:
Session 2>
BEGIN;
UPDATE band SET song=CONCAT ("Here Comes the ", song) WHERE song LIKE ' %Sun ; Which two are true?

A. Session 1 takes a shared lock on all the rows in the band table.

B. Session 2 takes an exclusive lock on all the rows in the band table.

C. Session 2 does not start a transaction.

D. Session 1 does not block Session 2.

E. Statements in Session 2 are committed.

F. Session 1 must commit before the update in Session 2 can complete.

Discussion 0

Correct Answer: E,F Vote an answer

Question #3

Examine this statement and output:

Which is true?

A. myview was defined with the temptable processing algorithm.

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

C. myview cannot be automatically indexed.

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

Discussion 0

Correct Answer: A Vote an answer

Question #4

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. An error occurs and the create table statement fails.

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

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

Discussion 0

Correct Answer: B Vote an answer

Question #5

Examine these my.cnf settings:

Examine this entry from /data/slow.log

Which option is also set in my.cnf?

A. log_throttle_queries_not_using_indexes=100

B. log_queries_not_using_indexes=ON

C. log__slow_admin_statements=1

D. log_queries_not_using_indexes

Discussion 0

Correct Answer: C Vote an answer

Question #6

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

D. SELECT CONCAT(last name,', ',first_name) FROM employees;

E. SELECT CONCAT_WS(', ',last_name,first_name) FROM employees;

Discussion 0

Correct Answer: D,E Vote an answer

Question #7

Examine the contents of these tables: