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 4177

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

2202

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

1 5169

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

2796

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

STC,

1 5179

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

1 6960

What is blocking and how would you troubleshoot it?

1 6647

Explain CREATE DATABASE syntax?

2 8495

How to start SQL Server in minimal configuration mode?

1 7830

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

3 8386

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

1 5347

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

1 4720

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

1 4355

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

TCS,

7 21378

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 11465

Post New DB Administration Questions

Un-Answered Questions { DB Administration }

What is replication? : sql server DBA

1108

Query processing is slow(eg select query)how will u solve that

7777

what are the benefits of flashback feature?

965

What is transparent data encryption? : sql server DBA

1130

what are the performance views in an oracle rac environment?

1006

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

2202

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

2374

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

1071

which background process invoke at the time of upgradation tell me???

2667

How would you best determine why your MVIEW couldn't FAST REFRESH?

2304

What purpose does the model database server? : sql server DBA

1108

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?

2410

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

2050

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

1017

What is a system database and what is a user database? : sql server DBA

1126

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