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

The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.


	What keyword does an SQL SELECT statement use for a string search?

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

	What is a transaction and what are ACID properties?

	What is the DEFAULT constraint in SQL Server?

	How do I create primary keys in SQL Server?



	What is DTS (Data Transformation Services) in SQL Server?

	Which join gives the Cartesian product of two tables in sql server?

	What is the advantage of Materialised View?

	How many Columns per SELECT statement is possible in SQL Server?

	Which function is used to find the largest integer less than or equal to a specific value?