Follow Our FB Page << CircleMedia.in >> 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?

IBM,

1 2306

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

1386

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?

1956

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

STC,

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?

TCS,

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?

170


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

146


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

156


How to start SQL Server in minimal configuration mode?

5941


Which autogrowth database setting is good? : sql server DBA

167






how can you implement fine-grained auditing?

159


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

1348


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

150


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

175


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

1500


What happens on checkpoint? : sql server DBA

153


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

150


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

156


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1377


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

3307