You are on page 1of 3

1. What is normalization? Explain different levels of normalization?


relationships while designing tables?

inside a bit column?
7. Define candidate key, alternate key, composite key.
8. What are defaults? Is there a column to which a default can't be

1. What is a transaction and what are ACID properties?
2. Explain different isolation levels
3. CREATE INDEX myIndex ON myTable(myColumn)

What type of Index will get created after executing the above
4. What's the maximum size of a row?
5. Explain Active/Active and Active/Passive cluster configurations
6. Explain the architecture of SQL Server
7. What is lock escalation?
8. What's the difference between DELETE TABLE and TRUNCATE TABLE

9. Explain the storage models of OLAP

10. What are the new features introduced in SQL Server 2000 (or the
changed between the previous version of SQL Server and the current
11. What are constraints? Explain different types of constraints.
12. Whar is an index? What are the types of indexes? How many
of this approach?

2. What are the steps you will take to improve performance of a poor
performing query?
resolving deadlocks?
5. What is blocking and how would you troubleshoot it?

Explain CREATE DATABASE syntax

1. How to restart SQL Server in single user mode? How to start SQL Server
in minimal configuration mode?
2. As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
3. What are statistics, under what circumstances they go out of date, how
do you update them?
4. What are the different ways of moving data/databases between servers
and databases in SQL Server?
5. Explian different types of BACKUPs avaialabe in SQL Server? Given a
6. What is database replicaion? What are the different types of replication
you can set up in SQL Server?
7. How to determine the service pack currently installed on SQL Server?

1. What are cursors? Explain different types of cursors. What are the
disadvantages of cursors? How can you avoid cursors?
2. Write down the general syntax for a SELECT statements covering all the
3. What is a join and explain different types of joins.
4. Can you have a nested transaction?
object by using T-SQL?
6. What is the system function to get the current user's user id?
7. What are triggers? How many triggers you can have on a table? How to
invoke a trigger on demand?
8. There is a trigger defined for INSERT operations on a table, in an OLTP
think of this implementation? Can this be implemented better?
9. What is a self join? Explain it with an example.