Tata Group SQL Developer Interview Questions and Answers

Q1. Tell me about yourself.
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Timing was around 10am
It was quite a normal online examination kind of environment 
People from the company were there to invigilate 
All were quite nice and helpful in case the exam got stuck

Q1. 
Ninja and Alien Language Order Problem
An alien dropped its dictionary while visiting Earth. The Ninja wants to determine the order of characters used in the alien language, based on the given list of wor...read more
Ans. 
Determine the order of characters in an alien language based on a list of words.
• Create a graph data structure to represent the relationships between characters in the words.

• Perform a topological sort on the graph to find the order of characters.

• Return the smallest lexicographical order of characters as the result.
Answered by AI
Add your answer
Q2. 
Check Duplicate Within K Distance
Given an array of integers arr of size N and an integer K, determine if there are any duplicate elements within a distance of K from each other in the array. Return "true...read more
Ans. 
Check if there are any duplicate elements within a distance of K from each other in the array.
• Iterate through the array and keep track of the indices of elements using a hashmap.

• For each element, check if it already exists in the hashmap within distance K.

• Return true if a duplicate is found within distance K, otherwise return false.
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Medium

Timing was 2pm when it started
Interviewer was polite

Q1. 
Kth Largest Element Problem Statement
Ninja enjoys working with numbers, and Alice challenges him to find the Kth largest value from a given list of numbers.
Input:
The first line contains an integer 'T...read more
Ans. 
The task is to find the Kth largest element in a given list of numbers for each test case.
• Read the number of test cases 'T'

• For each test case, read the number of elements 'N' and the Kth largest number to find 'K'

• Sort the array in descending order and output the Kth element
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Timing was 9 am onwards 
Interviewer was good enough

Q1. Self introduction and several basic communication skills
Add your answer

Q1. Several questions on Excel sap and other English
Add your answer