Database Administrator Interview Questions | Glassdoor

Database Administrator Interview Questions

"Database administrators specialize in ensuring the safety of the client's data. Candidates should be well-versed in database design, security, and backup. Expect a technical-based interview that will test your ability to restore or find a file, manage databases, and increase the efficiency of a backup. Excellent organizational and communication skills will show that you are the right fit for maintaining the company's database."

Top Interview Questions

Sort: RelevancePopular 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 536 Interview Questions