Travel Boutique Online Senior Software Development Engineer Interview Questions and Answers

General reasoning and Mathmatics Aptitude

Q1. Core Java and Coding questions
Add your answer

Q1. FInd the max triplets such that i
Ans. 
Find the max triplets such that i
• Sort the array in ascending order

• Iterate over the array and keep track of the maximum triplet

• Return the maximum triplet
Answered by AI
Add your answer
Q2. Find the duplicate record in MySQL table
Ans. 
Finding duplicate records in MySQL table
• Use GROUP BY and HAVING clause to group and filter duplicate records

• SELECT statement with COUNT(*) function can be used to count the number of occurrences

• UNIQUE constraint can be added to the table to prevent duplicates
Answered by AI
Add your answer

LC Medium+ easy questions

Q1. LC : easy medium questions
Add your answer

Q1. Design (LLD)+ DSA
Add your answer

Q1. Manager discussion
Add your answer

Q1. Core : DBMS , oops in depth coding: basic DSA questions based on Arrays, String.
Add your answer

Q1. He asked me graph questions ( medium level ) based on a node to root, and min cost to target. note: if you really want to crack the yata.com interview practice graph question and they ask a leetcode questi...read more
Add your answer

Hackerrank test : 3 questions
1. Simple Array
2. Recursion followed by DP
3. DFS/BFS Graph Question

Q1. DSA Interview : 1. Search in a rotated array 2. Maximum subarray problem 3. There are n dices with m faces , you have to print count or all the possible ways to get k sum : Recursion followed by DP Questio...read more
Add your answer

Q1. System Design Round : Design IRCTC , how does IRCTC reserve a seat? What kind of locking do they use?
Ans. 
IRCTC reserves seats using a complex system of availability checks and booking processes.
• IRCTC uses a combination of real-time availability checks and booking processes to reserve seats.

• The system checks for availability of seats in real-time and reserves them for a short period of time while the booking process is completed.

• IRCTC uses a locking mechanism to ensure that the same seat is not booked by multiple users at ...read more
Answered by AI
Add your answer
Q2. Design Makemytrip , how does makemytrip blocks the seat for 15 mins even if the payment doesnot go through?
Ans. 
Makemytrip blocks seat for 15 mins by using a hold on the seat inventory.
• Makemytrip uses a hold on the seat inventory to block the seat for 15 mins.

• If the payment doesn't go through, the hold is released and the seat becomes available again.

• This ensures that the seat is not booked by someone else during the payment process.

• The hold time can vary depending on the airline's policy.

• Makemytrip also sends reminders to compl
Answered by AI
Add your answer

Q1. Hiring Manger Round : Behavioral Questions
Add your answer
Q2. What are checked and unchecked exceptions?
Ans. 
Checked exceptions are checked at compile-time while unchecked exceptions are not.
• Checked exceptions are those that are checked at compile-time and must be handled by the programmer.

• Unchecked exceptions are those that are not checked at compile-time and can be handled or not handled by the programmer.

• Checked exceptions are subclasses of Exception class while unchecked exceptions are subclasses of RuntimeException class...read more
Answered by AI
Add your answer
Q3. Pros and cons of in-memory database , and distributed database
Ans. 
Comparison of in-memory and distributed databases
• In-memory databases are faster due to data being stored in RAM

• Distributed databases offer better scalability and fault tolerance

• In-memory databases are limited by available RAM

• Distributed databases require more complex setup and maintenance

• In-memory databases are suitable for real-time applications

• Distributed databases are suitable for large-scale applications with high
Answered by AI
Add your answer

Second number from array