Entrata Senior Engineering Lead Interview Questions and Answers

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
Answered by AI
Add your answer

Q1. Tell me about yourself?
Add your answer

There will be 3 coding questions given to us for solving,we need solve two questions compulsory.

Q1. Introduce yourself
Ans. 
I am a software engineer with 5 years of experience in developing web applications using Java, Spring, and Angular.
• 5 years of experience in software development

• Proficient in Java, Spring, and Angular

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. Questions related to frontend
Add your answer

Questions were high level

Q1. Asked on concepts of angular, and .net. Had 3 rounds in total.
Add your answer