SQL Server Interview Question and Answers

56. What are some of the objects held in a database?
  • Tables
  • Columns
  • Data types
  • Stored procedures
  • Triggers
  • Rules
  • Keys
  • Constraints
  • Defaults
  • Indexes
57. What is the difference between the HAVING clause and the WHERE clause?
  SQL Server Express applies the HAVING clause after it summarizes the data, whereas it applies the WHERE clause before it summarizes the data.
58. Name the three types of user-defined functions?
  • Scalar
  • Inline table–valued
  • Multi-statement table–valued.
59. What is an identity column?
  Identity columns provide an autoincrementing value for a table.
60. What component installs the OLEDB and ODBC drivers?
  The MDACs (Microsoft Data Access Components).

Page 12 of 15