a2zinterviews

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).