Agile, SQL and API Testing Interview Questions for Software Testing
54 Agile, SQL and API Testing questions with answers for software testing roles — 11 easy, 37 medium, 6 hard.
About Agile, SQL and API Testing
Covers Scrum ceremonies, user stories and acceptance criteria, SQL queries for validating data, and REST API testing with Postman, status codes and methods. These are now expected even for manual testers, and many interview rounds include a live SQL query or API question.
What is Agile testing?
Show answer
What is a user story and what are acceptance criteria?
Show answer
Tell me about a time you had to learn SQL or API testing quickly for a project.
Show answer
What is the difference between Scrum and Kanban for a tester?
Show answer
SQL: find the second highest salary from an employees table.
Show answer
SQL: count today's orders by status.
Show answer
What is the difference between PUT and PATCH?
Show answer
What is the difference between HTTP 401 and 403?
Show answer
What is the difference between path parameters, query parameters and the request body?
Show answer
What are Postman environments and the Collection Runner?
Show answer
What do you check when testing an API in Postman?
Show answer
How do you test database integrity using SQL?
Show answer
What is a sprint retrospective?
Show answer
What is CI/CD and how does testing fit?
Show answer
What is API testing and why is it important?
Show answer
What is the difference between DELETE and TRUNCATE?
Show answer
How do you test pagination, sorting and filtering through an API?
Show answer
What is the use of SQL GROUP BY and HAVING in test validation?
Show answer
Write SQL to verify an order was saved correctly.
Show answer
SQL: find duplicate emails.
Show answer
Explain SQL joins briefly.
Show answer
Write a SQL query to find duplicate records.
Show answer
What is a sprint planning meeting and what does QA contribute?
Show answer
What is a REST API?
Show answer
What is the difference between GET and POST?
Show answer
What are SQL constraints?
Show answer
What are common HTTP status codes?
Show answer
Scrum ceremonies and the tester's role?
Show answer
What is the definition of done?
Show answer
How do you test a REST API with authentication?
Show answer
How do you test an API using Postman?
Show answer
What is TDD vs BDD?
Show answer
What does INVEST mean for user stories?
Show answer
What is a Three Amigos session?
Show answer
Describe how you contributed in a sprint retrospective to improve quality.
Show answer
SQL: find orders that have no matching customer record.
Show answer
SQL: verify that soft-deleted users do not appear in the active users list.
Show answer
Search works fine in QA but is very slow in production. Could a missing database index be the reason, and how do you check?
Show answer
What is JSON schema validation in API testing?
Show answer
Write a Postman test script that checks the status is 201 and the response contains an id.
Show answer
How do you chain requests in Postman by passing a token from login to the next call?
Show answer
The UI shows the correct order total, but the database has a different value. What do you check?
Show answer
The sprint ends tomorrow and two stories are still in testing. What do you do?
Show answer
An API returns 200 OK but the body contains an error message. Is that a bug?
Show answer
How do you handle a product owner who keeps adding scope in the middle of a sprint?
Show answer
SQL: find customers who placed more than three orders in the last 30 days.
Show answer
How do you test API error handling for invalid input?
Show answer
How do you test a REST API that is not ready yet?
Show answer
SQL: find orders whose total does not match the sum of their order items.
Show answer
What is a database transaction and how do you test rollback?
Show answer
What is idempotency in APIs and how do you test it?
Show answer
How would you test rate limiting on a public API?
Show answer
How would you set up a testing approach for a new Agile team with no QA process?
Show answer
Frequently asked questions
How important is Agile, SQL and API Testing in Software Testing interviews?
Covers Scrum ceremonies, user stories and acceptance criteria, SQL queries for validating data, and REST API testing with Postman, status codes and methods. These are now expected even for manual testers, and many interview rounds include a live SQL query or API question.
How should I use the Agile, SQL and API Testing sheet?
Go top to bottom — easy to hard. Answer before opening each answer, tick what you solved and save misses to Last-Minute Revision.