Interview Questions -- SQL Server -- Part-4

                                   Following are the SQL Server advance interview questions.

Questions:-

• Have you created VIEWs and what are the types of views.
• Is it possible to use ORDER BY with in the view definition
• What is STORED PROCEDURE and its advantages.
• Is it possible to call one stored procedure with in a another procedure.
• What is User Defined Functions(UDF) and its advantages.
• What is SQL SERVER Profiler.
• Have you come across Execution Plan and what is the advantage.
• Have you involved SQL query tuning OR How do you improve query performance.
• How did you handle Error Handling OR Exception Handling.
• What is TRY,CATCH.
• Is it possible to call Function with in a function.
• Have you called function with in a Procedure.
• Have you used CURSOR and Can you explain the situation when you have used your carrier.
• What is alternative for CURSOR.
• What is trigger and its types.
• What is INDEX and its usage.
• How many types of INDEX available.
• what is the difference between CLUSTERED and NON CLUSTERED INDEX.

Please share your answer through comments.