Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2567

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

1500

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

1 3551

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

2080

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

STC,

1 3559

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

1 5551

What is blocking and how would you troubleshoot it?

1 5208

Explain CREATE DATABASE syntax?

2 5953

How to start SQL Server in minimal configuration mode?

1 6210

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

3 5947

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

1 3907

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

1 3028

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

1 2847

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

TCS,

7 17428

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 9073


Post New DB Administration Questions






Un-Answered Questions { DB Administration }

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

255


what are the types of connection load-balancing?

281


How do you open a cluster administrator? : sql server DBA

244


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

1502


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

1845






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?

1629


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1237


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

322


Where do you find the default index fill factor and how to change it? : sql server DBA

246


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

325


internal architecture

1412


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.

1339


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

274


what is logical system in sap basis

807


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

946