1. Manual Testing + Scenario-Based Questions
What is a Test Scenario? (Example: Login Page):
Positive: Verify login with valid credentials, verify "Remember Me" functionality, verify password masking.
Negative: Verify login with invalid username/password, verify login with empty fields, verify account lockout after multiple failed attempts.
Key Concepts:
Severity vs. Priority: Severity is the technical impact on functionality (e.g., app crash), while Priority is the business urgency (e.g., logo typo, but it's on the homepage).
Regression Testing: Testing existing functionality to ensure new changes didn't break it.
Boundary Value Analysis (BVA): Testing limits (e.g., age field 18-60, test with 17, 18, 60, 61).
Scenario Questions:
Scenario: A bug appears in production that was not caught. Action: Reproduce, analyze why it was missed (requirements, test cases, or environment), and add it to the regression suite.
Scenario: Developer says a bug cannot be reproduced. Action: Provide logs, screen recordings, environment details, and clear steps.
2. SQL is Must (Database Testing)
Essential Commands: SELECT, INSERT, UPDATE, DELETE, WHERE, ORDER BY, GROUP BY, HAVING.
Joins: INNER JOIN (matching rows), LEFT JOIN (all from left table), RIGHT JOIN (all from right table), FULL JOIN.
Intermediate Queries:
Find 2nd highest salary: SELECT MAX(Salary) FROM Employees WHERE Salary < (SELECT MAX(Salary) FROM Employees).
Duplicate Records: SELECT Name, COUNT(*) FROM Users GROUP BY Name HAVING COUNT(*) > 1.
Delete vs. Truncate: DELETE (DML, can be rolled back, uses WHERE), TRUNCATE (DDL, faster, removes all rows, cannot be rolled back).
Check Integrity: IS NULL / IS NOT NULL to check for missing data.
3. Basic Knowledge of Share Market (Domain Knowledge)
Key Terminology:
IPO (Initial Public Offering): First time a company offers shares to the public.
Primary vs. Secondary Market: Primary = new issues (IPOs), Secondary = trading existing shares.
Trading vs. Investment: Trading is short-term (minutes to months), Investment is long-term (years).
Order Types: Market Order (immediate), Limit Order (at a specific price), Stop-Loss (to limit losses).
Scenario Questions (Domain):
Scenario: A client wants to invest in an IPO. Action: Check the company's business model, subscription rates, and IPO details.
Scenario: Trading app is slow during market hours. Action: Check API latency, database query performance, and server load (Volume/Stress Testing).
4. Project-Related Questions
Describe your project: Focus on the objective, your role, and the technology stack.
What is the toughest bug you found? Use the STAR method (Situation, Task, Action, Result).
How do you handle incomplete requirements? Talk to stakeholders, BA, or developers. Create draft test scenarios to get approval.
How do you prepare test data? Use a mix of existing data (if allowed) or create synthetic data that mimics production.
5. Be Prepared of Resume Summary (Introduction)
Template: "Detail-oriented QA Analyst with [Number] years of experience in manual testing (web/mobile). Proficient in [SQL/Jira/Bug Tracking] and strong experience with [e-commerce/finance] domains. Proven ability to identify critical defects and improve software quality through structured testing methodologies."
Tips:
Tailor it to the job description (e.g., highlight "Share Market" or "SQL" if mentioned).
Keep it concise (3-4 lines).
Focus on accomplishments, not just tasks.
6. Final Interview Tips
When in doubt, think as a user.
Emphasize early testing (Shift Left) to save costs.
Mention your familiarity with Agile/Scrum processes.
Be prepared to explain the Defect Life Cycle (New -> Open -> Fixed -> Verified -> Closed).
Scenario-based Software Testing Interview Questions for 2026
16 Dec 2025 — Scenario-Based Software Testing Interview Questions (2026 Edition) * You are asked to test a login page with Email & Password fiel...
testRigor AI-Based Automated Testing Tool
SQL Interview Questions For Software Testers | PDF - Scribd
* 200 8. SQL Interview Questions for Testers. These SQL interview questions are very simple and mainly were used for interviewing ...
Scribd
SQL Query Interview Questions And Answer - Naukri.com
17 Jul 2025 — SQL Query Interview Questions And Answer * What is SQL? 2.2. * What is a database? 2.3. * What is a primary key, and why is it imp...
