SQL Server 2005 has following features
A. Dynamic Management Views
B. FILESTREAM
C. Powerpivot
D. In-memory capability
Answer:A
SQL Server 2005 has following features
A. Dynamic Management Views B. FILESTREAM C. Powerpivot D. In-memory capability
Explanation: SQL Server 2005 introduced DMVs (Dynamic Management Views), which are specialized views and functions that return server state information. FILESTREAM, Powerpivot and in-memory capability were introduced in 2008,2008 R2 and 2014 respectively.