- What is normalization
- What is an index and types of indexes. How many number of indexes can be used per table
- What is a constraint. Types of constraints
- What are code pages
- What is referential integrity
- What is a trigger
- What are different types of joins
- What is a self join
- Authentication mechanisms in Sql Server
- What are user defined stored procedures.
- What is INSTEAD OF trigger
- Difference between SQL server 7.0 and 2000
- How to optimize a query that retrieves data by joining 4 tables
- Usage of DTS
- How to disable an index using select query
- Is non-clustered index faster than clustered index
- Types of optimization in querries
- Difference between ISQL and OSQL
- How you log an exception directly into sql server what is used for this
- About Replication in Database
- What is the default optimization done in oracle and sql server
- How can i make a coulmn as unique
- How many no of tables can be joined in same sql server
- How many coulmns can exist per table
- About Sql Profiler usage
