2 medium questions and 1 hard
Engineers Interview Questions
843,939 engineers interview questions shared by candidates
From SQL: 1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project. For python: 1. Given a product data frame, the new record gets appended in table with the new timestamp for the product ID. Find out the latest data frame for that particular product with pandas.
SQL question: 1 table with player_id, log in date, and 2 other fields and was asked to calculate first day retention rate. First day retention rate is defined as the player who log in the 2nd straight day, after the first ever time they log into game.
Write an algorithm to return the intersect of two arrays.
Given an array of integers, how would you move the duplicate integers into a different array? What is the efficiency of your algorithm?
Q3) Few questions on design patterns(Interpreter/ Observer/State) etc.
1) Given an array of numbers where each number has a duplicate except one, write a program to return the lone number.
What is binary search tree? Whats the time complexity of inserting? deleting? seaching? What's the time complexity for the worse case?
Given two (huge) sets, what is an efficient way to find their intersection?
Test if a Binary tree is BST or not
Viewing 1501 - 1510 interview questions