Database Specialist Interview Questions
5K
Database Specialist interview questions shared by candidates
There were a lot of questions in relation to the inner workings of the files and file groups.
5 Answers↳
Thanks for your inputs. I feel very confident about SQL Server questions with 9 + years of experience.My worry is about the 1 hour online analytical test which is part of the f2f. Did you had them and any inputs you have on how to prepare for same. Less
↳
This was a pretty straight forward SQL test where you have to determine the output of some code or write some basic code based on table examples provide. There are a few pattern recognition questions as well. Less
↳
Was this position for MSSQL or Mysql?
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
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
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
can you briefly tell us your home back ground?
4 Answers↳
Names: Mugyenyi Raymond Age: 37 years Gender: Male Date of Birth: Feb 20th 1979 Permanent Address: Kanungu District, Kanyantorogo Sub-County, Nyamigoye Parish, Nyabihoko Village Less
↳
Name:Semujju Derick Age: 24 Gender: Male Date of birth: 12th May, 1996 Home District: Luwero, Luwero subcounty, kabakedi parish, nsanvu village. Less
↳
Name:Semujju Derick Age: 24 Gender: Male Date of birth: 12th May, 1996 Home District: Luwero, Luwero subcounty, kabakedi parish, nsanvu village. Less
Write a SQL query that will produce the 10Th largest salary from an Employees table.
3 Answers↳
Glass door wont let me edit but switch 6 to 10 as shown below SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 10 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY Less
↳
SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP 6 ORDER BY SALARY DESC) AS TENTHSALARY ORDER BY SALARY Less
↳
select top 10 percent topsalaries.salary from (select top 10 Salary from Employee order by Salary desc) as topsalaries order by topsalaries.Salary asc Less
Tell me about yourself?
3 Answers↳
Check my profile
↳
my Name is B.Shanmugaraj, My father name is A.Baskaran is a auto driver My Mother name is B.Ananadhi is house wife My sister name is B.suganaya Studied Diploma in teacher education My Brother Name is B.satish kumar studying 12 th standard i have studied Diploma in Electronics & communication Engg in 2008 first class Now I am working in Cms info system pvt ltd in vellore Branch Tamilnadu state as a coustion for ATM cash loading & Maintenance . I have working in this concern past one year Less
↳
Hi, I'm Baktha Vatsal Katakam, Done Masters in Computer Applications in 2012 from Mother Teressa P.G College, Hyderabad. Done Oracle DBA from Uclid IT Solutions, Hyderabad and searching job on it, as a fresher. Well versed with dba concepts like "9i-10g-11g", DB-Architecture, RMAN, DMTS-LMTS, LINUX(OEL). Less