Ernst & Young Senior Analyst Interview Questions, Process, and Tips

Q1. What are joins in SQL and their types
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• Types of joins include inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all rows from the left table and matching rows from the right table.

• Right join returns all rows from the right table and matching rows from the left table.

• Full outer join returns ...read more
Answered by AI
Add your answer
Q2. What
Add your answer

Q1. Data normalisation forms with example
Ans. 
Data normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization is achieved through a series of normal forms (1NF, 2NF, 3NF, BCNF, etc.)

• Each normal form has specific rules that must be followed to ensure data is properly organized

• For example, 1NF requires that each table have a primary key and that each column in the table be atomic (i.e. indivisible)

• 2NF ...read more
Answered by AI
Add your answer
Q2. Joins, group by, order by
Add your answer

Q1. Final round with team director
Add your answer

Q1. Frequency counter
Add your answer
Q2. Remove duplicates
Ans. 
Remove duplicates from an array of strings
• Iterate through the array and store each element in a Set to automatically remove duplicates

• Convert the Set back to an array to get the final result
Answered by AI
Add your answer

Q1. 3×3 multi dimensional array que.
Add your answer

Good test with basic knowledge

Q1. Are you aware of the job role?
Add your answer

Q1. Why you want to join us? Why you want to enter this field? Tell Me about yourself and your previous work experience. Technical questions related to database. Technical question related to Control and Risk....read more
Add your answer

Q1. Dcf, valuation general
Add your answer

Q1. General questions
Add your answer

Q1. Just stay focused and work on your communication skills. Be confident.
Add your answer