DB Administration Interview Questions
Questions Answers Views Company eMail

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?


1 2117

What are statistics, under what circumstances they go out of date, how do you update them?


What is RAID and what are different types of RAID configurations?

1 3119

What are the steps you will take to improve performance of a poor performing query?


What are the steps you will take, if you are tasked with securing an SQL Server?


1 3095

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 5164

What is blocking and how would you troubleshoot it?

1 4748

Explain CREATE DATABASE syntax?

2 5450

How to start SQL Server in minimal configuration mode?

1 5646

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 5168

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 3497

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 2591

How to determine the service pack currently installed on SQL Server?

1 2473

Explain the difference between a hot backup and a cold backup and the benefits associated with each?


7 16151

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 8323

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?


Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA


What types of replication are supported in sql server? : sql server DBA


What are the different sql server versions you have worked on? : sql server DBA


What are the different types of indexes available in sql server? : sql server DBA


How can you control the amount of free space in your index pages? : sql server DBA


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?


what is the use of recording information about current session?


how can you create a user-defined lock?


how can a session indicate its interest in receiving alerts?


What the different types of replication and why are they used? : sql server DBA


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.


what do you understand by flashback feature of oracle?