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


	How do I create primary keys in SQL Server?

	What is the difference between TRUNCATE and DELETE commands ?

	What are stored-procedures? And what are the advantages of using them.

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

	What is the use of DESC in SQL Server Query?



	What are defaults? Is there a column to which a default can’t be bound?

	What is the CASCADE action in SQL Server?

	What are the steps you will take to improve performance of a poor performing query in SQL Server?

	Which operator performs pattern matching in SQL Server?

	What is the maximum number of columns in a row in SQL Server?