Database developer sollicitatievragen
579
Sollicitatievragen voor een Database Developer gedeeld door sollicitantenMeest gestelde sollicitatievragen
1.find second max salary hint using count
4 antwoorden↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Minder
↳
SELECT max(salary) FROM emptable WHERE salary < (SELECT max(salary) FROM emptable); Minder
↳
select max(Emp_Sal) from Employee a where 1 = ( select count(*) from Employee b where b.Emp_Sal > a.Emp_Sal) Minder
How do java deal with hash collision?
2 antwoorden↳
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 Minder
Remove duplicates from table
2 antwoorden↳
Using Rowid or Having clause
↳
hdfs dfs -rm /table/duplicates
How much SQL do you know.
2 antwoorden↳
I answered that I used SQL for adding database data for programming a site.
↳
Tons, over 25 years.
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 antwoorden
Tell about OOPS concepts in java
2 antwoorden
Table with a single field with integer value. Write a query to display the field in both ascending and descending order.
2 antwoorden↳
Customerid is one of the integer values
↳
Select * from customers Order by customerid; Similarly, Select*from customers Order by customerid desc; Minder
How would you deal with a developer who writes bad code?
2 antwoorden↳
I personally would offer advice and point at similar solutions. I would not be confrontational and sort it out at release time if it was really bad. Perhaps I might want to inform my manager but this is down to level of competence. Nobody is ever wrong in my book, it all boils down to experience. Minder
↳
Tell them "You see all those tasks we have outsourced to India? Do you want yours to be as well? Write better code" Writing readable code is essential, writing efficient code even more so. If a developer cannot do that properly, they need a good scare. Minder