Cognizant interview question

Microsoft .NET MVC questions: what is MVC ? what is Routing ? difference between view and partial view ? SQL interview questions: What are constraints in sql ? difference between function and stored procedure? What is sql join? difference between drop,truncate and delete?