Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2567

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 3551

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 3559

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

1 5551

What is blocking and how would you troubleshoot it?

1 5208

Explain CREATE DATABASE syntax?

2 5953

How to start SQL Server in minimal configuration mode?

1 6210

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

3 5947

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

1 3907

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

1 3028

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

1 2847

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


7 17428

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 9073

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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


what are the types of connection load-balancing?


How do you open a cluster administrator? : sql server DBA


How would you best determine why your MVIEW couldn't FAST REFRESH?


which background process invoke at the time of upgradation tell me???


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?


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA


Where do you find the default index fill factor and how to change it? : sql server DBA


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA


internal architecture


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.


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


what is logical system in sap basis


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.