DB Administration Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 4374

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

2312

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

1 5455

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

2902

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

STC,

1 5395

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

1 7136

What is blocking and how would you troubleshoot it?

1 6849

Explain CREATE DATABASE syntax?

2 8758

How to start SQL Server in minimal configuration mode?

1 8093

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

3 8668

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

1 5528

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

1 4893

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

1 4539

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

TCS,

7 21881

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 11739

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What the different topologies in which replication can be configured? : sql server DBA

1319

How to start SQL Server in minimal configuration mode?

8093

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

1251

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

1048

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

1964

What happens on checkpoint? : sql server DBA

1146

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

2312

what do you understand by flashback feature of oracle?

1046

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1079

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

1808

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?

2580

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2509

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2526

What is replication? : sql server DBA

1238

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