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 3233

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

1786

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

1 4185

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

2394

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

STC,

1 4262

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

1 6157

What is blocking and how would you troubleshoot it?

1 5852

Explain CREATE DATABASE syntax?

2 6834

How to start SQL Server in minimal configuration mode?

1 6897

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

3 7013

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

1 4495

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

1 3780

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

1 3472

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

TCS,

7 19164

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 10130


Post New DB Administration Questions

Un-Answered Questions { DB Administration }

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

1628


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

2065


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

1812


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

2394


what is grd?

603






You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1515


Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1661


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

528


what are the differences of where and if in SAS?

1638


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

682


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

2207


What is replication? : sql server DBA

595


What happens on checkpoint? : sql server DBA

544


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

1661


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

6449