Question 31 : XML datatype was introduced in which of the following versions of SQL Server ?
1. SQL Server 2000
2. SQL Server 2005
3. SQL Server 2008
4. SQL Server 2012
View Answer   Discuss with Members

Question 32 : Which of the following part of the XML data stored in an XML column is very important for locking ?
1. Granularity
2. Degree of Structure
3. Hierarchy
4. None of the mentioned
View Answer   Discuss with Members

Question 33 : Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be:
1. You need language support for query and data modification for cross-domain applications
2. You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schema
3. You want indexing of XML data for efficient query processing and good scalability, and the use of a first-rate query optimizer
4. All of the mentioned
View Answer   Discuss with Members

Question 34 : What is hybrid model in SQL Server ?
1. Combination of relational and XML data type columns
2. Combination of relational and non relational data type columns
3. Using XML with views
4. Using XML with triggers
View Answer   Discuss with Members

Question 35 : XML View Technology is useful in the following situations:
1. Your application needs system catalog views to administer your XML data and XML schema
2. Indexing Capabilities
3. You want to bulk load XML data and decompose them into the underlying tables by using the XML view
4. None of the Mentioned
View Answer   Discuss with Members

Question 36 : In which of the following scenario,using XML native storage would be inappropriate ?
1. Fixed schema
2. You want to query and modify your XML data
3. You want to index the XML data for faster query processing
4. Your application needs system catalog views to administer your XML data and XML schema
View Answer   Discuss with Members

Question 37 : The choice of XML technology, native XML versus XML view, generally depends upon the following factors:
1. Storage options
2. Query capabilities
3. Indexing
4. All of the Mentioned
View Answer   Discuss with Members

Question 38 : Which of the following is not a XML storage option ?
1. Native storage as XML data type
2. Mapping between XML and relational storage
3. Small object storage
4. None of the Mentioned
View Answer   Discuss with Members

Question 39 : Which of the reasons will force you to use XML data model in SQL Server ?
1. Your data is sparse or you do not know the structure of the data
2. Your data represents containment hierarchy
3. Order is inherent in your data
4. All of the Mentioned
View Answer   Discuss with Members

Question 40 : Point out the wrong statement :
1. The Depth column comes in handy for performing the indent by using the Space() function
2. Stored procedures are the easiest way to extract hierarchical data
3. Inside SQL Server 2008, Microsoft introduces a new data type Index on HierarchyID to handle such type of data and reduce the complexity
4. None of the mentioned
View Answer   Discuss with Members