As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is RAID and what are different types of RAID configurations?1 3119
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?
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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
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
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
What types of replication are supported in sql server? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
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?
what is the use of recording information about current session?
how can you create a user-defined lock?
how can a session indicate its interest in receiving alerts?
What the different types of replication and why are they used? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what do you understand by flashback feature of oracle?