Interview Q&A

Short answer: Unit testing involves testing the smallest parts of an application (units) independently to ensure they work correctly. It is important because it helps detect bugs early, improves code quality, supports refactoring, and provides documentation for expected behavior.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Unit Testing: Tests individual units in isolation. Integration Testing: Tests interaction between multiple components or systems. Functional Testing: Tests end-to-end functionality from the user's perspective.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Assertions verify that the actual outcome of a test matches the expected result, determining if a test passes or fails.

Real-world example (ShopNest)

Arrange a cart with 2 items → Act Checkout() → Assert total and that payment was called once.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Code coverage measures the percentage of code executed by tests. It helps identify untested parts but doesn’t guarantee test quality. High coverage with meaningful tests improves confidence in code correctness. xUnit Framework

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: xUnit is a free, open-source unit testing framework for .NET, designed by the original authors of NUnit. It’s popular because it supports modern testing practices, is lightweight, extensible, integrates well with .NET Core and Visual Studio, and encourages clean, maintainable test code.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: public class CalculatorTests { [Fact] public void Add_ReturnsSum() { var calculator = new Calculator(); var result = calculator.Add(2, 3); Assert.Equal(5, result); } }

Example code

public class CalculatorTests
{ [Fact] public void Add_ReturnsSum()
{
var calculator = new Calculator();
var result = calculator.Add(2, 3); Assert.Equal(5, result); }
}

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: NUnit is a popular open-source unit testing framework for .NET. It allows developers to write and run automated tests by marking test methods with attributes. NUnit discovers and executes these tests, verifying that the code behaves as expected.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: [SetUp] runs code before each test method to prepare test environment. [TearDown] runs code after each test to clean up resources or reset state.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: [Test] marks a standard test method without parameters. [TestCase] provides inline parameter values to run the test multiple times with different inputs.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: MSTest is Microsoft's official unit testing framework for .NET. It’s tightly integrated with Visual Studio and is a good choice for teams using Microsoft tooling and wanting a straightforward, supported testing solution without external dependencies.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Mocking is creating fake objects that simulate the behavior of real dependencies. It’s important because it isolates the unit under test, avoids reliance on external systems, improves test speed, and allows testing specific scenarios and edge cases.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Moq is a popular, open-source mocking library for .NET that enables developers to create mock objects, set expectations, and verify interactions in unit tests, helping isolate dependencies easily.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: TDD is a software development approach where you write tests before writing the actual code. It follows a short, repetitive cycle of writing a failing test, implementing code to pass the test, and then refactoring.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: TDD writes tests before code, driving design and implementation. Traditional testing usually happens after coding, as a verification step. TDD promotes continuous testing and refactoring, while traditional testing may be more manual or batch-driven. Integration Testing

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Integration testing verifies that multiple components or systems work together correctly, unlike unit testing which tests individual units in isolation. It focuses on interactions between modules, databases, APIs, or external services.

Example code

Integration testing verifies that multiple components or systems work together correctly, unlike unit testing which tests individual units in isolation. It focuses on interactions between modules, databases, APIs, or external services.

Real-world example (ShopNest)

ShopNest unit tests cover pricing and discount rules so a bad coupon change fails in CI before customers see it.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: CHAR: A fixed-length string data type. It always reserves the same amount of space regardless of the string's length. Use case: When the length of the string is known and consistent. VARCHAR: A variable-length string data type. It only uses as much space as needed to store the string. Use case: When the string length can vary.

Example code

CREATE TABLE Example ( fixed_char CHAR(10), variable_char VARCHAR(10) );

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: The LIMIT clause is used to specify the number of records returned by a SELECT query. It is commonly used to restrict the number of rows, especially for pagination.

Example code

SELECT * FROM Employees LIMIT 5; This will return only the first 5 rows from the Employees table.

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: NULL represents the absence of a value in a column. It is not the same as an empty string or zero. Handling NULL: To check for NULL, use IS NULL or IS NOT NULL. To handle NULL in queries, use COALESCE() (returns the first non-NULL value) or IFNULL().

Example code

SELECT Name, IFNULL(Salary, 0) FROM Employees;

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: And does not log individual row deletions.

Explain a bit more

Cannot be rolled back (in most databases). And does not log individual row deletions. Cannot be rolled back (in most databases). nd does not log individual row deletions. Cannot be rolled back (in most databases). Resets auto-increment counters. DELETE: Deletes rows based on a condition, and can be rolled back (if using transactions). Slower compared to TRUNCATE. DELETE FROM Employees WHERE Age < 18; -- Deletes only specific rows TRUNCATE TABLE Employees; -- Deletes all rows nd does not log individual row deletions. Cannot be rolled back (in most databases). Resets auto-increment counters. DELETE: Deletes rows based on a condition, and can be rolled back (if using transactions). Slower compared to TRUNCATE.

Example code

DELETE FROM Employees WHERE Age < 18; -- Deletes only specific rows TRUNCATE TABLE Employees; -- Deletes all rows

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: TRUNCATE: Deletes all rows in a table, but the table structure remains. It is faster and does not log individual row deletions. Cannot be rolled back (in most databases). Resets auto-increment counters. DELETE: Deletes rows based on a condition, and can be rolled back (if using transactions). Slower compared to TRUNCATE.

Example code

DELETE FROM Employees WHERE Age < 18; -- Deletes only specific rows TRUNCATE TABLE Employees; -- Deletes all rows

Real-world example (ShopNest)

ShopNest’s SQL Server database stores customers, products, and orders. Good indexes and clear foreign keys keep checkout queries fast and safe.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: An Index is a database object that speeds up the retrieval of rows from a table by creating a data structure (often a B-tree). Indexes improve the performance of SELECT queries but can slow down INSERT, UPDATE, and DELETE operations.

Example code

CREATE INDEX idx_employee_name ON Employees(Name);

Real-world example (ShopNest)

ShopNest adds an index on Orders(CustomerId, CreatedAt) because “my recent orders” is queried constantly.

Say this in the interview

1. Define — one clear sentence (the short answer above).
2. Example — relate it to a project like ShopNest or your real work.
3. Trade-off — when you would not use it.

Short answer: Start with gratitude, then move to value: explain why you are excited about the role and why your impact justifies a better package. A post-offer negotiation works best when your ask is anchored in market data and your recent outcomes. Keep the tone collaborative so HR sees you as a long-term hire, not a short-term transaction.

Why this matters in Salary Negotiation

This is easiest to do in the first 24 to 48 hours after offer release, before background checks and onboarding steps begin.

Step-by-step approach

1. Thank HR for the offer and confirm you are seriously interested in joining.
2. Benchmark compensation for your exact role, location, and experience using at least three credible sources.
3. Prepare a one-page value brief with 3 achievements tied to revenue, cost, reliability, or delivery speed.
4. Share a clear expected range instead of one rigid number, and mention your ideal fixed-pay mix.
5. Discuss negotiable components like joining bonus, retention bonus, ESOP vesting, or appraisal cycle.
6. Close by asking when you can expect a revised offer so the process does not lose momentum.

Real-world example

Priya received an SDE-2 offer from Flipkart while working at TCS. She thanked the recruiter first, then shared numbers showing she reduced production incidents by 38% and cut API latency by 120 ms in her current role. Rahul, now at Razorpay, helped her present a range rather than a single demand. Flipkart revised her CTC upward and improved the fixed component, and Priya accepted confidently.

Numbers & benchmarks

• A practical negotiation range is usually 8% to 15% wide.
• For most professionals, keeping variable pay under 20% improves monthly cash-flow stability.
• A 24 to 48 hour response window after offer receipt is usually ideal for renegotiation.

Mistakes to avoid

• Jumping directly to money without first signaling interest in the role.
• Quoting random social-media salary figures with no role/location context.
• Using emotional language like "I deserve this" instead of evidence-based outcomes.
• Waiting until the joining date is near and creating unnecessary urgency.

Ask once, ask clearly, and support it with proof.

Short answer: A reasonable increase is one that reflects both market rate and your capability uplift. The right number depends on role criticality, tech stack rarity, and whether you are moving from support to core product ownership. Evaluate total compensation quality, not just percentage hike.

Step-by-step approach

1. Identify whether your move is lateral, step-up, or domain switch; each has different hike expectations.
2. Compare current responsibilities against target JD to estimate scope premium.
3. Benchmark at least 8 to 10 active job postings with disclosed ranges when available.
4. Separate fixed pay, variable pay, and benefits before concluding what is reasonable.
5. Stress-test offer sustainability by calculating post-tax take-home and annual volatility.
6. Choose only offers that improve both pay and learning trajectory.

Real-world example

Karthik worked in support engineering at Infosys and got an SRE role interview at Swiggy. His first instinct was to ask for 30%, but the role required incident leadership and automation ownership across teams. Neha from PhonePe helped him benchmark similar roles in Bengaluru and identify a better range. He negotiated a 47% increase with stronger fixed pay and still met company budget expectations.

Numbers & benchmarks

• Lateral switches often settle around 20% to 40%.
• Role-upgrade switches can move into 35% to 60% if demand is high.
• If variable pay is above 25%, verify historical payout before valuing it fully.

Mistakes to avoid

• Using one percentage rule for every type of role change.
• Counting retention bonus as guaranteed annual income.
• Ignoring city-level compensation differences while comparing offers.
• Choosing highest CTC even when role quality is weak.

Reasonable means market-aligned and sustainable for both sides.

Short answer: Freshers can negotiate, but the strategy is different: prove readiness, not tenure. If you have internships, strong projects, or competition wins, use them to justify a modest but meaningful revision. Focus on fixed pay and learning runway rather than only CTC headline.

Step-by-step approach

1. List practical signals of readiness: internships, open-source contributions, hackathon wins, or deployed apps.
2. Research entry-level pay ranges for your stack in your target city.
3. Ask for clarity on probation conversion, training timeline, and first review cycle.
4. Request a realistic improvement in fixed pay if total CTC cannot move much.
5. Negotiate onboarding support such as relocation assistance if applicable.
6. Confirm all terms in writing before signing the offer.

Real-world example

Ananya, a final-year student from Pune, got an offer from Infosys and another from a product startup in Chennai. She showed her internship results, including a dashboard feature adopted by 2,000 internal users. Vikram from Razorpay suggested she ask for a better fixed component and an early performance review. The startup increased fixed pay and offered a 6-month review milestone, which she accepted.

Numbers & benchmarks

• Even a 5% to 12% revision at fresher stage compounds strongly over 2 to 3 years.
• A 6-month review clause can be more valuable than a one-time sign-on bonus.
• If relocation is required, request clear relocation reimbursement limits upfront.

Mistakes to avoid

• Assuming freshers cannot negotiate at all.
• Asking for unrealistic jumps without portfolio proof.
• Ignoring probation terms and review timing.
• Selecting offer only by brand name without role quality.

As a fresher, negotiate with proof and humility.

Short answer: Email negotiation should be crisp, evidence-led, and respectful of timeline. A strong mail includes appreciation, rationale, expected range, and a clear next step. Keep it short enough to read in one screen but specific enough to approve.

Step-by-step approach

1. Use a precise subject line such as "Offer Discussion - [Your Name]".
2. Open with appreciation and confirm your interest in accepting the role.
3. Add 2 to 3 quantified reasons that support your revised expectation.
4. Mention your expected range and preferred structure in one clear paragraph.
5. Request a timeline for response and keep availability open for a call.
6. If no reply in two business days, send one professional follow-up.

Real-world example

Neha got an offer from Infosys while finishing interviews with two other firms. Instead of negotiating on chat, she sent a concise email with three impact metrics from her previous role at CRED and a realistic range. Arjun from Razorpay helped her remove emotional phrases and keep the message business-focused. HR replied the same day, revised the fixed pay, and closed the offer quickly.

What to say / email template

Hi [HR Name],

Thank you for sharing the offer. I am genuinely excited about this opportunity and would like to discuss compensation once before final acceptance.

Based on role scope and my recent outcomes in [domain] (for example: [metric 1], [metric 2], [metric 3]), I am targeting a CTC range of [X]-[Y], with preference for a stronger fixed component.

If feasible, please let me know whether we can review this. I am available for a quick call today/tomorrow.

Regards,
[Your Name]

Mistakes to avoid

• Writing long emotional mails without concrete evidence.
• Sending multiple reminders in a short span and appearing impatient.
• Using aggressive phrases like "final offer or I walk away."
• Forgetting to mention continued interest in joining.

One clear email beats five vague follow-ups.