Database specialist Interview Questions

4K

Database Specialist interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
G/O Digital
Database Administrator was asked...12 July 2015

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?

Show more responses
Charles Schwab

Do you need sponsorship for this position?

4 Answers

No

No

no

Show more responses
CMSS Private Limited

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

Show more responses
Ministry of Finance, Planning & Economic Development, Uganda

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

Show more responses

Where I would live to see myself in 5years

3 Answers

Being able to make great contributions and progress in the comp

To continue my education and get more experience in order to contribute to the success of the company Less

To see my self in a higher position

Tata Consultancy Services

What Will be your position in this company after 1 year?

2 Answers

Definately 100 % Increase Growth rate of company... i'm also on TOpmost position!!! Less

I will try my level best

Slalom

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

NCR

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

Sodexo

how do you work under pressure.

3 Answers

No

No

No

Oracle

oracle architecture, RAC, new features performance tuning ASM RMAN

3 Answers

read old version oracle books like 8i 9i for core concepts

after ow many days you received HR call

process starts once u clear 1st round. but it usually takes time.

Viewing 1 - 10 of 4,212 Interview Questions

See Interview Questions for Similar Jobs