As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

IBM,

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

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

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

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

STC,

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

What is blocking and how would you troubleshoot it?

Explain CREATE DATABASE syntax?

How to start SQL Server in minimal configuration mode?

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

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

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

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

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

TCS,

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?