Microsoft SQL Server MCQ Quiz (Multiple Choice Questions And Answers)
Are you preparing for the next job interviews? If yes, trust me this post will help you also we'll suggest you check out a big collection for Programming Full Forms that may help you in your interview:
List of Programming Full Forms
- Your data is sparse or you do not know the structure of the data
- Your data represents containment hierarchy
- Order is inherent in your data
- All of the Mentioned
- Combination of relational and XML data type columns
- Combination of relational and non relational data type columns
- Using XML with views
- Using XML with triggers
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008
- SQL Server 2014
30. Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be:
- You need language support for query and data modification for cross-domain applications
- You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schema
- You want indexing of XML data for efficient query processing and good scalability, and the use of a first-rate query optimizer
- All of the mentioned
