Interview Q&A

Short answer: And allow storage of unstructured or semi-structured data. They don't require a fixed schema and are often used for large-scale applications where flexibility, scalability, nd speed are more important than the strict relational model. Examples: MongoDB, Cassandra, CouchDB, Firebase

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: Define Roles: Define different roles based on business requirements (e.g., admin,? is a common interview topic in SQL & Databases. Give a clear definition, then one concrete example.

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: Snapshot testing is a way of testing a component’s rendered output by saving it to a snapshot file and comparing it with future renders. This helps detect any unintended changes in the UI. How to write snapshot tests: Run Jest with snapshot testing: npm test -- --updateSnapshot

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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 render props pattern is a technique for sharing code between components using a prop whose value is a function (a “render prop”). This function can return JSX or other values, allowing more dynamic behavior and custom rendering. Purpose: It enables a component to expose its logic while letting its consumers define how the output is rendered.

Example code

class MouseTracker extends React.Component { state = { x: 0, y: 0 }; handleMouseMove = (event) => { this.setState({ x: event.clientX, y: event.clientY, }); }; render() { return ( <div onMouseMove={this.handleMouseMove}> {this.props.render(this.state)} </div> ); } } const App = () => ( <MouseTracker render={({ x, y }) => ( <h1>The mouse position is ({x}, {y})</h1> )} /> ); In this example, MouseTracker uses the render prop pattern to allow the parent component to decide how to render the mouse position data.

Real-world example (ShopNest)

ProductCard receives price via props. The parent Catalog owns selected filters in state and passes them down.

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: llowing more dynamic behavior and custom rendering.

Explain a bit more

Purpose: It enables a component to expose its logic while letting its consumers define how the output is rendered.

Real-world example (ShopNest)

ProductCard receives price via props. The parent Catalog owns selected filters in state and passes them down.

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: Reconciliation is the process by which React updates the DOM efficiently when a component's state or props change.

Explain a bit more

React uses a virtual DOM to compare the new virtual DOM tree with the previous one and determines the minimal set of changes required to update the actual DOM. Key Concepts: Virtual DOM: A lightweight representation of the real DOM. Diffing algorithm: React’s algorithm compares the old and new virtual DOMs to find the differences (diffs) and apply the smallest set of changes. Reconciliation Flow:

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: React Fiber is a complete rewrite of React's reconciliation algorithm.

Explain a bit more

It is designed to improve the rendering performance and make React more responsive and capable of handling asynchronous rendering. Key Features: Incremental Rendering: React Fiber allows rendering to be split into chunks, so it can pause and resume work, improving responsiveness. Prioritization: React can assign different priority levels to updates (e.g., user input vs. background updates). Async Rendering: Enables non-blocking UI updates, making React apps feel more responsive.

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: Static Site Generation (SSG) is a technique where HTML pages are generated at build time. Unlike SSR, SSG pre-renders all pages during the build process, which results in faster load times. Example with Next.js (SSG): import React from 'react'; export async function getStaticProps() { const data = await fetchDataFromAPI();

Example code

return { props: { data } };
} function Page({ data }) { return <div>{data}</div>;
} export default Page; Here, getStaticProps is a Next.js function that fetches data during build time. The page is pre-rendered and served as static HTML.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: Hydration refers to the process where React takes over the static HTML rendered by the server and attaches event listeners and restores interactivity.

Explain a bit more

This happens once the JavaScript bundle is loaded on the client. SSR: Server renders the HTML. Hydration: React "hydrates" the server-rendered HTML to make it interactive. This process allows the page to load quickly (thanks to the server-rendered HTML) and then become fully interactive once React takes over. React Ecosystem & Tools

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: Next.js is a React framework that enables server-side rendering (SSR), static site generation (SSG), API routes, and more out-of-the-box.

Explain a bit more

It simplifies React app development by providing a set of conventions and features that improve performance, SEO, and developer experience. Why use Next.js? Server-Side Rendering (SSR): Automatically generates HTML on the server for better SEO and faster initial load. Static Site Generation (SSG): Pre-renders pages at build time, improving performance. Automatic Code Splitting: Only loads the necessary JavaScript for the current page. File-Based Routing: Routing is based on the file system, making navigation easier. API Routes: Allows you to build API endpoints directly inside your Next.js app. Image Optimization: Automatically optimizes images for better performance. Example: npx create-next-app my-next-app In this setup, the app can be SSR or SSG-enabled, providing better performance and SEO out of the box.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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 developer experience. Why use Next.js? Server-Side Rendering (SSR): Automatically generates HTML on the server for better SEO and faster initial load. Static Site Generation (SSG): Pre-renders pages at build time, improving performance. Automatic Code Splitting: Only loads the necessary JavaScript for the current page. File-Based Routing:… Routing is……… based on the file system, making navigation easier.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: Create React App (CRA) is a boilerplate tool to set up a modern React app without configuring build tools like Webpack, Babel, etc.

Explain a bit more

It’s designed to help you focus on writing code instead of spending time configuring tools. Features: Zero Configuration: It sets up Webpack, Babel, ESLint, and other essential tools. Development Server: Provides a development server with hot reloading. Production Build: Automates production optimizations like minification, asset optimization, etc. How to Use CRA: npx create-react-app my-app cd my-app npm start With CRA, you don’t have to manually configure Webpack or Babel. It gives you everything you need to start building React applications right away.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: PropTypes is a runtime type-checking library used to validate the types of props passed to React components. It helps catch errors during development by ensuring that props match the expected data types.

Example code

import PropTypes from 'prop-types'; function MyComponent({ name, age }) { return <div>{name} is {age} years old</div>; } MyComponent.propTypes = { name: PropTypes.string.isRequired, age: PropTypes.number.isRequired, }; In this example, PropTypes.string.isRequired ensures that the name prop is a string and is required. If it’s not passed or is of the wrong type, React will display a warning in the console.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: ge: PropTypes.number.isRequired, }; In this example, PropTypes.string.isRequired ensures that the name prop is a string nd is required. If it’s not passed or is of the wrong type, React will display a warning in the console.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: React Native is a framework for building native mobile applications (iOS and Android) using React and JavaScript.

Explain a bit more

While React is for web development, React Native allows you to create mobile apps with a similar paradigm but using native components (e.g., <View> instead of <div>). Key Differences: React: Builds for the web, rendering HTML and managing DOM. React Native: Builds for mobile, using native components and APIs for interaction with mobile devices (camera, geolocation, etc.). Example in React Native: import { Text, View } from 'react-native'; function App() { return ( <View> <Text>Hello, React Native!</Text> </View> ); } In React Native, the components map to native UI elements, such as <Text> for text, <View> for containers, and <Button> for buttons.

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: Reconciliation is the process React uses to update the UI efficiently when state or props change.

Explain a bit more

React compares the old virtual DOM with the new virtual DOM and calculates the minimal set of changes required to update the real DOM. This makes React apps fast and efficient. Why important: It helps React determine the minimal updates needed, avoiding unnecessary re-renders. React uses a diffing algorithm to compare previous and current states to optimize DOM updates.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: React: Library for building UI, focusing on components and rendering.

Explain a bit more

Declarative and flexible: Use JavaScript to write components. React has a rich ecosystem, but you often need additional libraries for routing, state management, etc. Angular: Framework: Full-fledged framework for building web apps. Uses TypeScript by default and has built-in solutions for routing, HTTP requests, form handling, and more. Two-way data binding: Automatically synchronizes model and view. Vue: Framework: Similar to React, but provides two-way binding and template syntax. Easier to integrate into existing projects. Flexibility: Offers the reactivity model and simplicity in syntax.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: ngular: Framework: Full-fledged framework for building web apps. Uses TypeScript by default and has built-in solutions for routing, HTTP requests, form handling, and more.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: JSX transpilation refers to the process of converting JSX syntax (JavaScript XML) into regular JavaScript. Since browsers don't understand JSX directly, tools like Babel transpile JSX into valid JavaScript that browsers can execute.

Example code

const element = <h1>Hello, world!</h1>; Babel transpiles the JSX into: const element = React.createElement('h1', null, 'Hello, world!');

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: Concurrent Mode is an experimental feature in React that enables the rendering process to be interruptible. It allows React to work on multiple tasks at once, making apps feel more responsive by prioritizing higher-priority updates (like animations or user input) over lower-priority ones.

Real-world example (ShopNest)

ShopNest’s storefront is React: components for ProductCard, CartDrawer, and CheckoutForm, with hooks for local UI state.

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: Use DENSE_RANK() or OFFSET/FETCH. Prefer DENSE_RANK when ties matter. Avoid brittle MAX(salary) WHERE salary < MAX(salary) without discussing ties.

Problem statement

Employees(EmpId, Name, Salary). Return the second highest distinct salary.

Interview approach

1. Ask whether “second highest” means distinct salaries or second row after sort.
2. Show DENSE_RANK for distinct ranks.
3. Mention TOP 1 ... WHERE Salary < (SELECT MAX(Salary) ...) as older style.

Sample solution

-- Option A: DENSE_RANK (handles ties cleanly)
SELECT Salary
FROM (
    SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary DESC) AS rnk
    FROM Employees
) t
WHERE rnk = 2;

-- Option B: OFFSET/FETCH (SQL Server)
SELECT DISTINCT Salary
FROM Employees
ORDER BY Salary DESC
OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

Edge cases to mention

• Fewer than 2 distinct salaries
• NULL salaries
• Multiple employees sharing the top salary

Common follow-ups

• Nth highest salary
• Second highest per department

Say DENSE_RANK vs RANK out loud — panels love that distinction.

Short answer: An ATS-friendly resume is simple, keyword-aligned, and evidence-based. Use plain formatting so systems can parse sections correctly, then make each bullet prove measurable impact. If ATS can read it and a recruiter can scan it in 20 seconds, you are on the right track.

Step-by-step approach

1. Use a single-column layout with standard headings like Summary, Skills, Experience, and Projects.
2. Extract required keywords from JD and incorporate them naturally in skills and bullets.
3. Rewrite every bullet as Action + Context + Result with numbers where possible.
4. Remove tables, icons, and text boxes that often break ATS parsing.
5. Keep file as PDF or DOCX only if the job portal specifically supports it.
6. Run a final ATS score check and human readability review before applying.

Real-world example

Priya applied to 40 roles from TCS and got almost no callbacks. Rahul from Razorpay reviewed her resume and found heavy design formatting with missing backend keywords. She rebuilt it into a clean one-column format with impact metrics for latency and uptime improvements. Callback rate improved within two weeks.

Mistakes to avoid

• Using visually rich templates that ATS cannot parse properly.
• Stuffing keywords unnaturally and reducing readability.
• Listing responsibilities without measurable outcomes.
• Submitting same resume to all roles without adaptation.

Toolliyo resources

• Resume Builder
• ATS Rewriter

Readable by machine first, impressive to human next.

Short answer: A professional summary should state role identity, core strengths, and business impact in 3 to 4 lines. It is not an objective statement or motivational quote. Think of it as your positioning headline for recruiter skimming.

Step-by-step approach

1. Start with your role + years of experience + core domain in one sentence.
2. Add 2 key strengths aligned to target job requirements.
3. Include one measurable achievement that supports credibility.
4. Mention preferred scope, for example product backend or ML platform work.
5. Keep total length under 70 words for readability.
6. Customize summary slightly for each major role type you apply to.

Real-world example

Karthik’s resume opened with a vague line: "Seeking challenging opportunities." Isha from PhonePe helped him rewrite the summary to mention backend expertise, payment-domain experience, and latency improvement outcomes. Recruiters could now understand his profile in seconds. He started receiving more relevant interview calls.

Mistakes to avoid

• Using generic objective lines with no role signal.
• Writing a 150-word paragraph that no recruiter reads.
• Adding personal adjectives without proof.
• Forgetting to align summary with target job type.

Your summary should answer: who are you, what can you deliver?

Short answer: No-experience resumes should highlight projects, internships, coursework relevance, and problem-solving evidence. Recruiters know you are entry-level; they want proof that you can execute and learn quickly. A focused project-first resume can outperform a generic fresher template.

Step-by-step approach

1. Open with a clear summary of target role and relevant technical stack.
2. Prioritize academic or personal projects with measurable outcomes.
3. Add internships, hackathons, open-source work, or freelancing if available.
4. Keep skills limited to tools you can explain confidently in interviews.
5. Include links to GitHub, portfolio, and deployed demos.
6. Tailor project keywords to each role before applying.

Real-world example

Ananya was a fresher from Hyderabad with no full-time work history. Vikram from Infosys helped her place projects above education and add measurable outcomes for each build. She added GitHub links and one deployed app demo in her resume header. Her profile started receiving internship-to-full-time callbacks.

Mistakes to avoid

• Leaving project section vague with no outcomes.
• Adding every class assignment as if it were production work.
• Listing advanced skills without practical proof.
• Ignoring portfolio links in resume.

For freshers, projects are your experience.

Short answer: Tailoring means changing emphasis, not inventing experience. Mirror the job language, prioritize relevant achievements, and remove distracting content. A targeted resume dramatically improves ATS match and recruiter response rate.

Step-by-step approach

1. Read JD carefully and mark required skills, domain context, and responsibility keywords.
2. Reorder experience bullets so most relevant impact appears first.
3. Swap project examples to match target role expectations.
4. Adjust summary line to reflect role title and domain focus.
5. Update skills section to emphasize directly relevant tools.
6. Run a quick ATS keyword-gap check before submitting.

Real-world example

Meera used one generic resume for all roles while applying from Infosys. Rohit from Freshworks showed her how to create two versions: backend-heavy and data-heavy. She reordered bullets and projects based on each JD instead of rewriting from scratch. Her interviews became more relevant and conversion improved.

Mistakes to avoid

• Copy-pasting JD words without matching evidence.
• Changing everything and losing profile authenticity.
• Keeping irrelevant projects at top due to personal preference.
• Sending same resume to fundamentally different role types.

Toolliyo resources

• Resume Builder
• ATS Rewriter

Tailor emphasis, never fabricate experience.