C-Sharp (C#) Interview Questions and Answers (FAQs)


	What are the pros and cons of creating extended stored procedures?

	What is the difference between a primary key and a unique key?

	What is DTC (Distributed Transaction Coordinator) in SQL Server?

	How to find out column names and their datatypes in a given table using a query in SQL Server?

	The reason why views are created in SQL Server?



	What is a View in SQL Server?

	What is the UNIQUE KEY constraint in SQL Server?

	What is the basic functions for master, msdb, model, tempdb databases?

	What is the CASCADE action in SQL Server?

	What are the benefits of using Stored Procedures in SQL Server? OR Why should we use Stored Procedures?