1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category
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 3267

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

 1799

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

 1 4218

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

 2409

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

STC,

1 4290

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

 1 6184

What is blocking and how would you troubleshoot it?

 1 5886

Explain CREATE DATABASE syntax?

 2 6870

How to start SQL Server in minimal configuration mode?

 1 6922

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

3 7069

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

 1 4528

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

 1 3811

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

 1 3497

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

TCS,

7 19245

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 10176

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

How do you troubleshoot errors in a sql server agent job? : sql server DBA

552

what is the role of dip user in our database?

2034

how can you find out if a table can be redefined?

589

what are the benefits of flashback feature?

581

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

1674




How to start SQL Server in minimal configuration mode?

6922

Explain materialized views and how they are used.

1880

how can you enable flashback feature?

528

what are the differences of where and if in SAS?

1654

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

565

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

602

what do you understand by flashback feature of oracle?

545

what is logical system in sap basis

1116

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3298

what is a crs resource?

582

For More Un-Answered { DB Administration } Questions Click Here