AmbitionBox Sdet Lead Interview Questions and Answers

Q1. How Indexing works in DB
Ans. 
Indexing in DB is a technique to improve the speed of data retrieval by creating a data structure that allows for quick lookup of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include B-tree, hash, and bitmap indexes.

• Indexes can be unique or non-unique, clustered or non-clustered.

• Example: Creating an index on the 'email' column ...read more
Answered by AI
Add your answer
Q2. Spring Boot depenencies
Add your answer

Q1. System Design of Bookmyshow
Ans. 
Bookmyshow is a popular online ticketing platform for movies, events, and other entertainment.
• Bookmyshow allows users to browse and book tickets for movies, events, plays, sports, etc.

• The system should have features like seat selection, payment gateway integration, booking history, and notifications.

• Scalability is important to handle high traffic during popular movie releases or events.

• Integration with cinema partners ...read more
Answered by AI
Add your answer
Q2. Some SQL queries to write
Add your answer

Easy questions but less time

2 easy and 1 hard leet code

Q1. Reverse the link list
Ans. 
Reverse a linked list
• Iterate through the linked list and reverse the pointers

• Use three pointers - prev, current, next to reverse the links

• Update the head of the linked list to the last node after reversing
Answered by AI
Add your answer
Q2. The Hanoi tower problem was given
Add your answer
Q3. One DP question was given to explain not write
Add your answer

Q1. JEE rank and previous paid internship
Add your answer

Q1. Core java, multi-threading, oops, etc.
Add your answer
Q2. Get all permutations of an array.
Ans. 
Get all permutations of an array.
• Use recursion to swap elements and generate permutations

• Iterate through the array and swap elements at each index

• Use a set to avoid duplicates
Answered by AI
Add your answer

Q1. Tick the words boxes that best describes yourself.
Add your answer
Q2. Tick the words boxes that best describes your vision of a perfect employer.
Add your answer

Had to solve 50 questions in 12 minutes. Questions were very easy, only headache was to attempt as many as you could in 12 minutes. .

Had questions regarding core subjects in the multiple choice section in the 1st section of this round. In the section 2nd of this round you had 3 questions of data structures (2 easy and 1 of moderate difficulty level).

Q1. Interview revolved around Data Structures and DBMS (particularly SQL).
Add your answer

Q1. Standard HR questions that you probably gonna expect in every other company.
Add your answer

2 coding questions will be there

System design questions will be asked for sde 2

Q1. Ready to work from office
Add your answer

Basic Apti and Behavioural Online Round 15-30 minutes

1.5 hrs long. 3 Problems Easy to Medium

Q1. Cogoport was mass hiring, so interview was only 30 minutes long. Basic DSA, sorting, and SQL queries.
Add your answer
Q2. Merge Sort Algorithm
Ans. 
Merge Sort is a divide and conquer algorithm that divides the input array into two halves, sorts them separately, and then merges them.
• Divide the array into two halves recursively

• Sort each half separately using merge sort

• Merge the sorted halves back together
Answered by AI
Add your answer
Q3. SQL Query Basic Join
Add your answer

Q1. 5-7 minutes final HR round
Add your answer