Technical Software Engineering Interview MCQ Practice Quiz 2026

Question 1

In a Next.js 14 App Router application, you have a client component displaying a live chart that re-renders every second. Subordinate form inputs on the same page lag noticeably when the user types. What is the most effective architectural fix?

Accepted Answer

Isolate the live chart state into its own leaf component and use useTransition for non-urgent input updates

Answer

Wrap the entire page component inside React.memo()

Answer

Switch the entire page to a Server Component with revalidate = 1

Answer

Store the input value directly in localStorage instead of React component state

Question 2

Which HTTP header and configuration best ensures that static JavaScript bundles are aggressively cached by browsers while ensuring instant cache invalidation upon a new deployment?

Accepted Answer

Cache-Control: public, max-age=31536000, immutable with content-hashed filenames

Answer

Cache-Control: no-cache, no-store, must-revalidate

Answer

ETag header only without Cache-Control

Answer

Cache-Control: public, max-age=3600 with fixed filenames

Question 3

A PostgreSQL query filtering on 'status = active' and ordering by 'created_at DESC' on a 10M-row orders table takes 3.8s. An EXPLAIN ANALYZE shows an explicit Sort step consuming 90% of execution time. What index addresses this?

Accepted Answer

CREATE INDEX idx_orders_status_created ON orders(status, created_at DESC);

Answer

CREATE INDEX idx_orders_status ON orders(status);

Answer

CREATE INDEX idx_orders_created ON orders(created_at DESC);

Answer

CREATE HASH INDEX idx_orders_composite ON orders(status, created_at);

Question 4

You are designing a distributed rate limiter for an API handling 200,000 requests/sec across 50 container instances. Which Redis data structure and algorithm provides atomic precision with minimal memory overhead?

Accepted Answer

Redis Token Bucket implemented via Lua script using HSET/EVAL

Answer

Redis Sorted Set (ZSET) storing timestamps with ZREMRANGEBYSCORE

Answer

Generic String GET and SET with in-application sleep loop

Answer

Redis PUB/SUB broadcasting every incoming request

Question 5

During a major holiday sale, your primary database reaches 98% CPU utilization and incoming API requests begin timing out with HTTP 504. What is your best immediate first mitigation step?

Accepted Answer

Activate a database read-replica or Redis caching for read queries, and rate-limit non-critical search endpoints

Answer

Immediately begin sharding the database across multiple physical servers

Answer

Restart the database instance to clear active memory and connections

Answer

Drop historical transaction tables to free up disk space

Question 6

In SQL, what is the key difference between ROW_NUMBER(), RANK(), and DENSE_RANK() when ordering values that contain exact ties (e.g. scores 100, 90, 90, 80)?

Accepted Answer

ROW_NUMBER assigns unique sequential integers (1,2,3,4); RANK leaves gaps after ties (1,2,2,4); DENSE_RANK leaves no gaps (1,2,2,3)

Answer

ROW_NUMBER skips numbers on ties; RANK assigns random order; DENSE_RANK averages the tie values

Answer

DENSE_RANK leaves gaps after ties, while RANK assigns unique integers

Answer

All three window functions behave identically in PostgreSQL and MySQL

Question 7

You train a classification model on an imbalanced fraud dataset (99.5% legitimate transactions, 0.5% fraud). The model achieves 99.5% accuracy but catches 0% of fraud cases. Which metric must you optimize instead?

Accepted Answer

Precision-Recall AUC (PR-AUC) and F1-Score (or F2-Score focusing on Recall)

Answer

Mean Squared Error (MSE)

Answer

R-Squared (Coefficient of Determination)

Answer

Increase accuracy to 99.9% by training for 100 more epochs

Question 8

You run an A/B test on a new sign-up flow. The test variant shows a statistically significant 15% increase in signups (p < 0.01), but day-7 retention drops by 20%. What is your recommended product decision?

Accepted Answer

Do not ship to 100%; analyze whether the variant introduced low-intent users or obscured value clarity, causing downstream churn

Answer

Launch variant immediately because top-of-funnel user growth is the North Star metric

Answer

Extend the test for 6 months without taking action

Answer

Remove day-7 retention from the dashboard to highlight signup victory

Question 9

A client company wants to enter an adjacent B2B SaaS market. Their core advantage is an established enterprise sales team, but they have zero engineering experience in the new domain. Which market entry mode provides the lowest risk-adjusted time-to-market?

Accepted Answer

Strategic acquisition of a small product-market-fit startup or white-label partnership, distribution-led

Answer

Build the product completely in-house from scratch over 3 years

Answer

Exit their current business and pivot entirely to the new market

Answer

Run aggressive TV and billboard marketing before building any product

Question 10

An essential public health relief supply truck is blocked at a district border due to a minor bureaucratic permit typo. Hospital patients in your jurisdiction require these medicines within hours. What should the presiding administrative officer do?

Accepted Answer

Grant provisional provisional clearance under emergency administrative powers, record an official transit memo, and verify documentation concurrently

Answer

Turn the truck around and require a 5-day formal re-application process to maintain rigid documentation

Answer

Instruct field staff to ignore the situation so personal responsibility is avoided

Answer

Privately accept an informal cash fee from the driver to speed up clearance

Technical Interview MCQ Practice with In-Depth Explanations

In a Next.js 14 App Router application, you have a client component displaying a live chart that re-renders every second. Subordinate form inputs on the same page lag noticeably when the user types. What is the most effective architectural fix?

Which HTTP header and configuration best ensures that static JavaScript bundles are aggressively cached by browsers while ensuring instant cache invalidation upon a new deployment?

A PostgreSQL query filtering on 'status = active' and ordering by 'created_at DESC' on a 10M-row orders table takes 3.8s. An EXPLAIN ANALYZE shows an explicit Sort step consuming 90% of execution time. What index addresses this?

You are designing a distributed rate limiter for an API handling 200,000 requests/sec across 50 container instances. Which Redis data structure and algorithm provides atomic precision with minimal memory overhead?

During a major holiday sale, your primary database reaches 98% CPU utilization and incoming API requests begin timing out with HTTP 504. What is your best immediate first mitigation step?

In SQL, what is the key difference between ROW_NUMBER(), RANK(), and DENSE_RANK() when ordering values that contain exact ties (e.g. scores 100, 90, 90, 80)?

You train a classification model on an imbalanced fraud dataset (99.5% legitimate transactions, 0.5% fraud). The model achieves 99.5% accuracy but catches 0% of fraud cases. Which metric must you optimize instead?

You run an A/B test on a new sign-up flow. The test variant shows a statistically significant 15% increase in signups (p < 0.01), but day-7 retention drops by 20%. What is your recommended product decision?

A client company wants to enter an adjacent B2B SaaS market. Their core advantage is an established enterprise sales team, but they have zero engineering experience in the new domain. Which market entry mode provides the lowest risk-adjusted time-to-market?

An essential public health relief supply truck is blocked at a district border due to a minor bureaucratic permit typo. Hospital patients in your jurisdiction require these medicines within hours. What should the presiding administrative officer do?

What is the primary architectural difference between React 18 Server Components (RSC) and traditional Client-Side Hydration (SSR with getInitialProps / getServerSideProps)?

Consider the following JavaScript execution: console.log(1); setTimeout(() => console.log(2), 0); Promise.resolve().then(() => console.log(3)); queueMicrotask(() => console.log(4)); console.log(5); In what order are the numbers printed?

In a TypeScript project, you have an API response that returns either { status: 'success', data: User } or { status: 'error', error: string }. What is the recommended type-safe pattern to handle both variants without type casting?

A CPU-intensive image compression algorithm running on a Node.js Express server is causing high response latency for lightweight health check and user profile endpoints. What is the root cause and the best resolution?

Under PostgreSQL's default READ COMMITTED isolation level, which concurrency phenomenon is prevented, and which phenomenon can still occur within the same transaction?

A hot cache key (e.g. homepage top products) in Redis expires during peak traffic, causing 50,000 concurrent requests to hit the primary relational database simultaneously, crashing the DB. What is this phenomenon called and how is it prevented?

According to the CAP theorem in distributed systems, when a network partition (P) occurs between two data centers, what fundamental trade-off must system architects choose between?

A payment gateway webhook delivers transaction success notifications. Due to network retries, the webhook URL receives the exact same event payload 4 times over 30 seconds. How should the backend ensure the user's wallet is credited only once?

Why are Docker Multi-Stage Builds considered an industry best practice for compiling and containerizing Next.js or Go applications?

What is the key functional difference between a Kubernetes Liveness Probe and a Readiness Probe?

You need to parse and filter a 40GB server log file on a machine with only 8GB of RAM in Python. Which implementation avoids Out-Of-Memory (OOM) termination?

In an enterprise Retrieval-Augmented Generation (RAG) system, why is a two-stage retrieval pipeline (Bi-Encoder Dense Vector Search followed by Cross-Encoder Re-Ranking) preferred over vector search alone?

What causes 'Thrashing' in an Operating System's Virtual Memory management subsystem?

Why do relational database engines (PostgreSQL, MySQL InnoDB) use B+ Trees rather than standard Binary Search Trees (BST) or Hash Tables as the default index structure?

During the establishment of a secure HTTPS connection over TCP and TLS 1.3, what is the minimum round-trip time (RTT) overhead required before application data can be transmitted on a resumed session?

Turn Technical Mastery into 3x More Recruiter Interviews

How Technical MCQ Rounds Work in 2026 Tech Hiring

1. Conceptual Depth Over Syntax

2. Trade-Off Evaluation

3. Campus & SDE-1 Placement Cutoffs

3 Golden Rules for Scoring High on Technical MCQ Rounds

Frequently Asked Questions

What topics are covered in VayloAI Technical Interview MCQs?

Are multiple choice questions used in real tech company hiring?

How can I prepare for behavioral and system design vocal rounds?

Are your technical skills visible to ATS resume scanners?