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 4158

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

2195

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

1 5143

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

2791

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

STC,

1 5166

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

1 6943

What is blocking and how would you troubleshoot it?

1 6629

Explain CREATE DATABASE syntax?

2 8464

How to start SQL Server in minimal configuration mode?

1 7804

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

3 8364

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

1 5332

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

1 4710

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

1 4336

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

TCS,

7 21338

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 11439

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1039

what is logical system in sap basis

1575

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2134

Where would you look for errors from the database engine?

2791

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

937

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2226

what is a user-defined lock?

983

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1042

how can you enable flashback feature?

893

What is dcl? : sql server DBA

1184

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

1884

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1021

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

932

how can a session indicate its interest in receiving alerts?

979

internal architecture

2140

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