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 2117

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

1296

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

1 3119




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

1857

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

STC,

1 3095

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

1 5164

What is blocking and how would you troubleshoot it?

1 4748

Explain CREATE DATABASE syntax?

2 5450




How to start SQL Server in minimal configuration mode?

1 5646

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

3 5168

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

1 3497

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

1 2591

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

1 2473

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

TCS,

7 16151

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 8323


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

1717


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

993


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

78


If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

69


What types of replication are supported in sql server? : sql server DBA

63






What are the different sql server versions you have worked on? : sql server DBA

60


What are the different types of indexes available in sql server? : sql server DBA

68


How can you control the amount of free space in your index pages? : sql server DBA

76


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?

1374


what is the use of recording information about current session?

89


how can you create a user-defined lock?

75


how can a session indicate its interest in receiving alerts?

64


What the different types of replication and why are they used? : sql server DBA

65


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1271


what do you understand by flashback feature of oracle?

73