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.
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?
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?
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?
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()`?
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?
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?
What is the primary purpose of using a SAVEPOINT within a database transaction?
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?
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.