ExamDumpster

Free 1Z0-909 sample questions

These free 1Z0-909 sample questions each come with the answer and an explanation. They cover connectors, transactions and isolation levels, stored routines and JSON. Use them to test how well you know MySQL behavior, not just SQL syntax.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

A developer is writing a prepared statement in a Java application to prevent SQL injection. The query needs to fetch a user by their integer ID. What is the correct placeholder to use in the SQL string for the prepared statement?

Question 2Choose one

A table stores geographic locations of retail stores using a `POINT` data type. A query is needed to find all stores within a 10-kilometer radius of a given coordinate. Which function is best suited for this calculation?

Question 3Choose one

You need to create a trigger that prevents a product's price from being updated to a value less than its cost. The `products` table has `price` and `cost` columns. Which combination of trigger time and event is correct for this requirement?

Question 4Choose one

A query returns an unexpected result set, and you suspect it's due to the current session's SQL mode. Which command would you use to view the SQL mode settings for only your current connection?

Question 5Choose one

When using the MySQL Shell in JavaScript mode to interact with a Document Store, which object is the entry point for performing collection-level operations like `find()`, `add()`, or `createIndex()`?

Question 6Choose one

You are analyzing a query's performance using `EXPLAIN`. The `Extra` column for a joined table shows `Using where; Using index`. What does this indicate about the query's execution for that table?

Question 7Choose one

A developer needs to store international product descriptions. The descriptions can contain a wide variety of characters from different languages, including emojis. Which character set and column type combination is most appropriate for this `description` column?

Question 8Choose one

What is the primary purpose of using a SAVEPOINT within a database transaction?

Question 9Choose one

A stored function is created to calculate a customer's lifetime value based on their orders. This calculation is complex and resource-intensive. To allow the query optimizer to better cache results from this function, how should it be declared?

Question 10Choose one

True or False: A composite index on columns `(A, B)` can be effectively used by the query optimizer to satisfy a `WHERE` clause condition of `B = 5`.

10 more free samples are waiting

Create a free account to unlock the whole 1Z0-909 sample bank, or get full access to all 200 practice questions in the simulator.

Create account