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 2306

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 3318

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 3280

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

1 5339

What is blocking and how would you troubleshoot it?

1 4975

Explain CREATE DATABASE syntax?

2 5673

How to start SQL Server in minimal configuration mode?

1 5941

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

3 5507

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

1 3683

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

1 2763

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

1 2633

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


7 16802

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 8651

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

what is grd?


What is the difference between dropping a database and taking a database offline? : sql server DBA


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA


How to start SQL Server in minimal configuration mode?


Which autogrowth database setting is good? : sql server DBA


how can you implement fine-grained auditing?


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?


What is the default fill factor value? : sql server DBA


What authentication modes does sql server support? : sql server DBA


How would you extract DDL of a table without using a GUI tool?


What happens on checkpoint? : sql server DBA


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


What is a correlated sub-query? : sql server DBA


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me