Database Interview Questions

Database Interview Questions

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