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


	What is the difference between TRUNCATE and DELETE commands ?

	How do I create primary keys in SQL Server?

	What is an execution plan? When would you use it? How would you view the execution plan?

	How to determine the service pack currently installed on SQL Server?

	How to find nth highest salary from Employee table in SQL Server?



	What are some SQL aggregates and built-in functions?

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

	State true or false. EXISTS, SOME, ANY are operators in SQL ?

	What is a transaction and what are ACID properties?

	What is the primary key in SQL Server?