Database Engineer Interview Questions
987
Database Engineer interview questions shared by candidates
How do java deal with hash collision?
4 Answers↳
link them
↳
There's quite an extended back and forth in actual interviews for questions like this, so there's no real replacement for actual practice. The Prepfully Comscore Database Developer experts have actually worked in this role, so they're able to do a propermock, which really puts you through the paces and lets you assess your readiness level. prepfully.com/practice-interviews Less
↳
By chaining
1.find second max salary hint using count
4 Answers↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Less
↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Less
↳
select max(Emp_Sal) from Employee a where 1 = ( select count(*) from Employee b where b.Emp_Sal > a.Emp_Sal) Less
Remove duplicates from table
4 Answers↳
Using Rowid or Having clause
↳
hdfs dfs -rm /table/duplicates
↳
Delete from table group by empID having count(empID)>1
How much SQL do you know.
2 Answers↳
Tons, over 25 years.
↳
I answered that I used SQL for adding database data for programming a site.
They gave me a sheet of queries to write and tasks to complete in a sample database that they had built including a few "if you have time" questions, and left me to do that on my own for about a half hour before reviewing what I had done.
2 Answers
