Database Administration Interview Questions | Glassdoor

Database Administration Interview Questions

514

Database administration interview questions shared by candidates

Top Interview Questions

Sort: Relevance Popular Date

Write an efficient stored procedure to allocate unique integer ids.

1 Answer

CREATEPROCEDURE [dbo].[AllocateUniqueIntIds] AS BEGIN SelectABS(CAST(CAST(NEWID()ASVARBINARY(5))ASBigint))as UniqueIntegerId END Go /* Test the store proc */ Exec [dbo].[AllocateUniqueIntIds] //Not sure if this is the correct answer

Explain way to improve their current 15 hours database backup.

1 Answer

How would you handle a difference of opinion between yours and a Senior technical member?

2 Answers

Easiet technical interview ever...

2 Answers

Questions where you have to write code

1 Answer

How much do you expect to make here? (Something to that extent.)

1 Answer

What are my career goals?

1 Answer

When confronted with a database incident, what steps would you take to resolve?

1 Answer

If you have a small project that uses a shared server how do you insure the data cannot be compromised by other users. Some may be DBA's

1 Answer

The questions I was asked during the technical screens were based on my experience and questions related to said experience.

1 Answer
110 of 514 Interview Questions