Tbo Holidays SQL Engineer Interview Questions and Answers

Good

Q1. Basic question from C++.Some questions from Data structure and computer architecture.
Add your answer

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

Q1. 
Find the Duplicate Number Problem Statement
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...read more
Ans. 
Find the duplicate number in an array of integers from 0 to (N-2).
• Iterate through the array and keep track of the frequency of each number using a hashmap.

• Return the number with a frequency greater than 1 as the duplicate number.

• Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.
Answered by AI
Add your answer
Q2. 
Reverse String Operations Problem Statement
You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...read more
Ans. 
Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.
• Iterate through the array of indices and reverse the substrings accordingly

• Ensure the range specified by each index is non-empty

• Return the final string after all operations are completed
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Round duration - 45 minutes
Round difficulty - Hard

All mcqs should answer with in time limit should have a lot of practice to solve in exam

Q1. 
Water Jug Problem Statement
You have two water jugs with capacities X and Y liters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to...read more
Ans. 
The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.
• Start by considering the constraints and limitations of the problem.

• Think about how the operations allowed can be used to reach the target measurement.

• Consider different scenarios and test cases to come up with a solution.

• Implement a function that takes the capacities of the jugs and the targe...read more
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Easy and just basic questions very easy round

Q1. 
Matrix Multiplication Task
Given two sparse matrices MAT1 and MAT2 of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl...read more
Ans. 
Implement a function to multiply two sparse matrices and return the resulting matrix.
• Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.

• Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.

• Ensure to handle the sparse nature of the matrices to optimize the multiplication process.

• Consider the constraints provided to en...read more
Answered by AI
Add your answer

Q1. Asked basic HR question as to why i want to join, what am i looking for , ever faced any harships in my internship.
Add your answer
Q2. Why did i puckup coding and biggest regret, weakness, strengths.
Add your answer