SQL Server Interview Question and Answers

61. What is denormalization and when would you go for it?
  Denormalization is the process of attempting to optimize the performance of a database by adding redundant data or by grouping data.Denormalization is the reverse process of normalization.
62. What keyword do you use to assign a value to a variable?
  The SELECT keyword.
63. What are the advantages of SQL Server 2005 Express?
  • SQL Server 2005 Express is free and is easy to use.
  • It provides the same protection and information management provided by more sophisticated versions of SQL Server.
  • It is easy to install, provides rich database functionality, and sports deep integration with Visual Studio 2005.
64. What function finds the difference between two dates?
  The DATEDIFF function.
65. What does the RETURN statement do?
  The RETURN statement unconditionally exits a stored procedure without executing any other statements.

Page 13 of 15