SQL DBA Interview Questions Answers
* Why do you like to be a DBA?
* Explain your skill set?
* Explain the environments you have worked in?
* What are your day to day tasks?
* What all tasks you have automated?
* How do you manage multiple SQL Servers?
Standards and Best practices
* Tell some standards and best practices you have implemented?
* How do you plan for the patching of SQL Server Service Packs and hotfixes?
* What is the difference between an index reorganization and an index rebuild?
Backup / Restore
* How will you validate if the backup is successful?
* How do you identify and rectify a performance issue?
* Name a few DBCC commands which you use for database administration?
* How do you backup the Analysis Services Databases?
* How you can take a Full backup without disturbing the LSNs?
* How do you plan for backup retention period?
Disaster Recovery
* How do you do a Point in Time recovery?
* What are the factors while designing the Disaster Recovery strategy?
* What is your database deployment strategy?
* What are the type of locks?
* How do you handle a deadlock issue?
* What is the difference between a fully-logged and minimally-logged operation?
* What is a query plan?
Monitoring
* Which all monitoring tools you have used including 3rd party softwares?
* Which third party tool is your favorite for Change Management, Backup Compression, Performance monitoring and Alerting?
* What may be the reasons for a huge MSDB database and how can you shrink it?
* Which all Windows performance monitor counters you use?
* Tell some DBCC commands and DMVs which you use on daily basis?
* How SQL Server does the memory management?
* How do you plan the memory distribution between the SQL Server and Operating system?
* What is the correlation between processors and number of temporary databases?
* What happens in the background when SQL Server service is restarted?
* What do you mean by database suspect mode and how do you repair a suspected database?
No comments:
Post a Comment