bp Data Engineer Interview Questions and Answers

Q1. What is the purpose of using Common Table Expressions (CTE) in SQL?
Ans. 
CTEs are used in SQL to create temporary result sets that can be referenced within a query.
• CTEs improve readability and maintainability of complex queries

• They can be recursively referenced to solve hierarchical problems

• CTEs can be used to simplify queries by breaking them into smaller, more manageable parts
Answered by AI
Add your answer

Q1. LRU Cache Implementation
Add your answer

2 question :

1. Find the longest common subsequence in 2 strings
2. find the 5th highest revenue from the table in last 28 days in a particular region

I was given a list of book, genre of books and books and rating of books . All list was of equal length n.

There were 2 methods which need to be implemented
1. get highest rating of book by genre . if rating are same then in lexographical order
2. update book rating by book name

Q1. These questions were basic
Add your answer
Q2. There were lots of imaginative situation given and then I was asked to say what I would do in those situation
Add your answer

First round was online assessment test with programming and aptitude games

Q1. Group Anagram question
Add your answer
Q2. SQL question to get name of employee whose salary is greater than average salary of the department
Ans. 
SQL query to retrieve name of employee with salary greater than department average.
• Calculate average salary of department using GROUP BY clause

• Join employee and department tables using department ID

• Filter employees with salary greater than department average

• Select employee name
Answered by AI
View 1 more answer