Website Developers India interview question

Q1. What is indexing? Different types of indexing in MS SQL Q2. Query optimization techniques Q3. Difference between function and stored procedure Q4. Use of temp table and magic table Q5. Can we delete records from views? What is the use view? Q6. Types of constraints