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 4284

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

2253

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

1 5311

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

2849

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

STC,

1 5298

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

1 7056

What is blocking and how would you troubleshoot it?

1 6748

Explain CREATE DATABASE syntax?

2 8644

How to start SQL Server in minimal configuration mode?

1 7975

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

3 8543

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

1 5441

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

1 4820

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

1 4446

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

TCS,

7 21627

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 11612

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

2849

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

1008

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

1908

when does an alert gets signaled?

1053

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2720

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1047

what is asm?

1052

What the different components in replication and what is their use? : sql server DBA

1051

What are the operating modes in which database mirroring runs? : sql server DBA

1188

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

1936

What is dbcc? : sql server DBA

1291

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2551

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

2471

What happens on checkpoint? : sql server DBA

1095

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