SQL and Databases
What is the difference between OLTP and OLAP systems?
How would you optimize a slow SQL query?
Explain the concepts of primary key, foreign key, and unique key.
Write a query to find duplicate records in a table.
How do you handle NULL values in SQL?
What are indexes, and how do they impact query performance?
What is a transaction, and how does ACID compliance ensure data integrity
1
Application
I interviewed at Tata Consultancy Services
Interview
As a fresher, you need to go through an online assessment, technical interview and a HR interview. Sometimes you can also expect Managerial round before HR round. You can expect questions from the skillset which was mentioned in your resume
Interview questions [1]
Question 1
They focused on the basic and important skills like Python and SQL, most of the questions are from the skillset you mentioned in your resume
I interviewed at Tata Consultancy Services (Noida)
Interview
3 rounds of interview, sql codes on paper and databricks question.
Manager round
Hr round
It was the whole day process all the processes that completed in a single day
Interview questions [1]
Question 1
100 GB data have to move but pipeline can handle 30gb
I interviewed at Tata Consultancy Services (Hyderabad)
Interview
Interview. was taken by bot. It was easy i answered everything perfectly. But i didn’t receive any email regarding the interview if i selected or not nothing. We would expect something reply from them right