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?



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 2039

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 1801

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

1 4109

What is blocking and how would you troubleshoot it?

1 3668

Explain CREATE DATABASE syntax?

2 4250

How to start SQL Server in minimal configuration mode?

1 4117

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

3 3532

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

1 2652

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

1 1727

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

1 1693

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


7 11432

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 6385

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?


currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba


I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB


Why does Oracle not permit the use of PCTUSED with indexes?


I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution


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


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


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


what is the role of dip user in our database?


what is logical system in sap basis


Query processing is slow(eg select query)how will u solve that


how can you connect from 10g user to 11g user??


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com


what are the differences of where and if in SAS?