Explanation:QL Server 2012 SP1 introduces a new type of XML index known as a Selective XML Index.This new index can improve querying performance over data stored as XML in SQL Server, allow for much faster indexing of large XML data workloads. 5. Point out the wrong statement :
A. SQL Server supports only two index types: clustered and non-clustered
B. Appropriate indexes can make a world of difference in performance.
C. SET option requires ALTER permission on the table or view.
D. None of the mentioned
Answer:A
Explanation:QL Server 2012 SP1 introduces a new type of XML index known as a Selective XML Index.This new index can improve querying performance over data stored as XML in SQL Server, allow for much faster indexing of large XML data workloads. 5. Point out the wrong statement :
A. SQL Server supports only two index types: clustered and non-clustered B. Appropriate indexes can make a world of difference in performance. C. SET option requires ALTER permission on the table or view. D. None of the mentioned
Explanation:There are plenty of indexes in SQL Server such as full text,columnstore index in SQL Server 2012 6. By default, indexes are stored in the ______ filegroup as the base table on which the index is created.