Mad Street Den Interview Questions and Answers

2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).

Q1. 1 easy coding and design problem on how would you design a web app like book my show.
Add your answer

Basic aptitude. and some sql and coding

Coding basic , some leetcode. some db ques

Some coding, some db some leetcode

Q1. More focused on past experience
Add your answer

Drag and drop application in prefered language

Q1. Technical discussion on past experience
Add your answer
Q2. DSA (leetcode easy)
Add your answer

Q1. VP discussion on scenario-based question to test dsa (recursion)
Ans. 
Discussing recursion in data structures and algorithms for a front-end engineer role.
• Recursion is a method where the solution to a problem depends on solutions to smaller instances of the same problem.

• Example: Calculating factorial of a number n using recursion: factorial(n) = n * factorial(n-1).

• Base case is crucial to prevent infinite recursion; e.g., factorial(0) = 1.

• Recursion can be less efficient than iteration due...read more
Answered by AI
Add your answer

Q1. Salary negotiation
Add your answer

Basic coding and ML related MCQs

Q1. Machine Learning and Deep Learning based questions. In depth working of networks and project related questions.
Add your answer

Q1. Sql and data related interview.
Add your answer

Q1. Basic fitness assessment.
Add your answer

Q1. Tool wise rise the questions
Add your answer

Q1. Pervious experience and design wise questions
Add your answer

Q1. What is closure
Ans. 
Closure is a feature in programming languages that allows a function to access variables from its outer scope even after it has finished executing.
• Closure is created when a nested function references variables from its parent function.

• It allows for data encapsulation and privacy in JavaScript.

• Closures are commonly used in event handlers, callbacks, and asynchronous programming.

• They can be used to create private variabl...read more
Answered by AI
Add your answer
Q2. How JS handles hoisting
Ans. 
JS hoisting is a mechanism where variable and function declarations are moved to the top of their scope during compilation.
• Variable declarations are hoisted but not their initializations.

• Function declarations are fully hoisted, including their definitions.

• Hoisting can lead to unexpected behavior if not understood properly.

• Example: console.log(x); var x = 5; // Output: undefined
Answered by AI
Add your answer
Q3. What are the different CSS position properties
Ans. 
CSS position properties determine how an element is positioned on a web page.
• static: default position, elements flow in document order

• relative: positioned relative to its normal position

• absolute: positioned relative to its nearest positioned ancestor

• fixed: positioned relative to the browser window

• sticky: positioned based on scroll position
Answered by AI
Add your answer

Q1. What are the different component lifecycles in react
Ans. 
React has several component lifecycles, including mounting, updating, and unmounting.
• Mounting: when a component is being created and inserted into the DOM

• Updating: when a component is being re-rendered due to changes in props or state

• Unmounting: when a component is being removed from the DOM
Answered by AI
Add your answer
Q2. What is the use of ref in react
Ans. 
Ref is used in React to access and manipulate the DOM directly.
• Ref provides a way to access and modify DOM elements or React components.

• It is commonly used for focusing input fields, triggering animations, or integrating with third-party libraries.

• Ref can be created using the useRef() hook or by using the ref attribute in class components.

• Example: const inputRef = useRef();

• Example: const button...read more
Answered by AI
Add your answer

Q1. Design the DB for slack
Ans. 
Designing the database for Slack
• Create tables for users, channels, messages, and teams

• Use foreign keys to establish relationships between tables

• Include columns for user details, channel details, message content, and timestamps

• Consider indexing frequently queried columns for performance optimization
Answered by AI
Add your answer
Q2. How will you improve the db performanc
Ans. 
To improve db performance, optimize queries, use indexing, cache data, and scale horizontally.
• Optimize queries by using appropriate indexes and avoiding unnecessary joins

• Cache frequently accessed data to reduce database load

• Scale horizontally by distributing the database across multiple servers

• Use database monitoring tools to identify and resolve performance bottlenecks
Answered by AI
Add your answer

Q1. Explain the projects that you worked on
Add your answer
Q2. What is CDN and list its uses
Ans. 
CDN stands for Content Delivery Network. It is a distributed network of servers that helps deliver web content efficiently.
• CDN improves website performance by caching content closer to the user

• It reduces latency and improves page load times

• CDN helps handle high traffic loads and prevents server overload

• It provides global coverage and ensures content availability worldwide

• CDN can deliver various types of content like im...read more
Answered by AI
Add your answer
Q3. How will improve the api latency of a system
Ans. 
To improve API latency, optimize database queries, use caching, implement load balancing, and optimize code.
• Optimize database queries by using indexes, reducing unnecessary joins, and optimizing query execution plans.

• Implement caching to store frequently accessed data in memory, reducing the need for repeated database queries.

• Use load balancing to distribute incoming requests across multiple servers, preventing any sin...read more
Answered by AI
Add your answer