Filter interviews by
Clear (1)
I applied via Campus Placement
Questions was regarding sql queries mostly
I applied via Campus Placement and was interviewed in Dec 2021. There were 2 interview rounds.
Group discussion was on a topic not related to computer science. It was a topic that anyone could speak.
WHERE clause is used to filter data in SQL queries.
WHERE clause is used after the FROM clause in a SQL query.
It is used to specify a condition that must be met for the query to return data.
Multiple conditions can be combined using logical operators such as AND and OR.
Examples: SELECT * FROM customers WHERE age > 18;
Examples: SELECT * FROM orders WHERE status = 'shipped' AND total_amount > 1000;
Joins in SQL are used to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables in a single query
There are different types of joins such as inner join, left join, right join, and full outer join
Inner join returns only the matching rows from both tables
Left join returns all the rows from the left table and matching rows from the right table
Right join returns a...
I applied via Campus Placement and was interviewed in Mar 2021. There were 4 interview rounds.
Top trending discussions
I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed before Jan 2020. There were 4 interview rounds.
I was interviewed before Nov 2020.
Round duration - 360 minutes
Round difficulty - Medium
They give you 6 hr. For 6 question but the good part is that you need to complete atleast 1 question and you are good to go.
Round will be cleared only after attempting one question and rest of the questions are for improving your rank.
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Find pairs of elements in an array that sum up to a given value, sorted in a specific order.
Iterate through the array and for each element, check if the complement (S - current element) exists in a hash set.
If the complement exists, add the pair to the result list.
Sort the result list based on the criteria mentioned in the problem statement.
You are given the arrival and departure times of N trains at a railway station for a particular day. Your task is to determine the minimum number of pl...
The task is to determine the minimum number of platforms needed at a railway station based on arrival and departure times of trains.
Sort the arrival and departure times in ascending order.
Use two pointers to keep track of overlapping schedules.
Increment platform count when a new train arrives before the previous one departs.
You are given a matrix of 'N' rows and 'M' columns and a non-negative integer 'K'. Determine the minimum possible sum of all elements in each submatrix after performing at m...
Given a matrix and a non-negative integer K, find the minimum possible sum of all elements in each submatrix after performing at most K decrements.
Iterate through all submatrices and find the minimum possible sum after performing decrements
Keep track of the number of decrements performed on each element
Use dynamic programming to optimize the solution
Ensure not to decrease any number below 0
Return the minimum possible s
You are given an array/list CHOCOLATES
of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M'...
Distribute chocolates among students to minimize the difference between the largest and smallest number of chocolates.
Sort the array of chocolates packets.
Use sliding window technique to find the minimum difference between the largest and smallest packets distributed to students.
Consider edge cases like when number of students is equal to number of packets.
You are given two integers DAY_HOURS
and PARTS
. Consider a day with DAY_HOURS
hours, which can be divided into PARTS
equal parts. Your task is to determine the total ins...
Calculate total instances of equivalent prime groups in a day divided into equal parts.
Divide the day into equal parts and find prime numbers in each part.
Identify prime groups where prime numbers occur at the same position in different parts.
Count the total instances of equivalent prime groups.
Ensure each hour in a prime group is in a different part of the day.
Given a matrix named UNIVERSE
with 3 rows and 'N' columns, filled with characters {#, *, .}, where:
The task is to identify constellations shaped like vowels within a matrix filled with characters {#, *, .}.
Iterate through the matrix to find 3x3 constellations shaped like vowels.
Check for vowels 'A', 'E', 'I', 'O', 'U' in each 3x3 constellation.
Print the vowels found in each constellation for each test case.
Round duration - 20 Minutes
Round difficulty - Easy
Tip 1 : learn basics
Tip 2 : learn any oops language and practice.
Tip 3 : code as much as you can.
Tip 1 : short and precise. Upto the point.
Tip 2 : keep few things aside from resume
I applied via Company Website and was interviewed before Feb 2021. There were 3 interview rounds.
TNQT: TCS National Qualifier Test
posted on 23 Mar 2015
During my summer training, I learned various programming languages, software development methodologies, and practical application of theoretical concepts.
Learned programming languages such as Java, Python, and SQL
Gained knowledge of software development methodologies like Agile and Waterfall
Applied theoretical concepts in real-world projects, enhancing problem-solving skills
posted on 7 May 2017
I was interviewed before May 2016.
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
Continuing to enhance my technical skills through ongoing learning and certifications
Taking on more leadership responsibilities within the team
Contributing to the company's growth and success through my expertise
Mentoring junior team members to help them grow in their careers
posted on 27 Aug 2015
based on 1 interview
Interview experience
based on 16 reviews
Rating in categories
Senior Analyst
436
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Analyst
319
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Analyst
221
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
190
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
145
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech