QA · Mid-level · Theory

How do you use SQL in your work as a tester? And tell me how you'd write a query that finds the users who placed more than one order in the last month.

~4 min by voice

How to approach it

They're checking that SQL is a working tool for you as a tester, not theory: you can verify data in the database, prepare it, and deliberately write an aggregate query (GROUP BY + HAVING), understanding the order of execution and the risks of changing data on shared environments.

Have you seen this question in a real interview?

Answers0

Avg. score—

Strong—

Practiced0

Topics

sql test data

Similar questions

You have a query with window functions over a billion-row events table, and it takes forty minutes. How would you investigate, and what would you optimize? Senior Automated tests run in parallel in eight processes against a single test environment and keep conflicting over identical emails and logins. Write a test user factory: it returns a valid user with unique fields, lets you override any field, and can create the user through the API with automatic cleanup after the test. Senior A query that used to run in milliseconds now takes seconds after the table grew to tens of millions of rows. How would you investigate, and what can you do about it? Mid-level What are a primary key and a foreign key? And how would you model a many-to-many relationship, for example students and courses? Junior In which cases would you deliberately denormalize a database schema, and what's the price you pay for it? Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Best with headphones · ~4 min