Question 21 : Point out the wrong statement
1. Typed XML type and Untyped XML both have XML schema to validate the Data
2. Typed XML type has advantage of storage and query optimizations where as Untyped XML type does not have this advantage
3. Typed XML types can be validated at both client side and Server side where as Untyped XML types does not have option to validate on server side as they do not have any schema
4. None of the mentioned
View Answer   Discuss with Members

Question 22 : Use untyped XML data type in the following situations:
1. You have schema for your XML data and you want the server to validate your XML data according to the XML schema
2. You want to take advantage of storage and query optimizations based on type information
3. You want to take better advantage of type information during compilation of your queries
4. You do not have a schema for your XML data
View Answer   Discuss with Members

Question 23 : Which operation cannot be performed on XML schema collection ?
1. DROP
2. DELETE
3. CREATE
4. UPDATE
View Answer   Discuss with Members

Question 24 : Which of the following statement would import additional schema or schema components into an existing collection object ?
1. IMPORT XML SCHEMA COLLECTION
2. ALTER XML SCHEMA COLLECTION
3. UPDATE XML SCHEMA COLLECTION
4. ADD XML SCHEMA COLLECTION
View Answer   Discuss with Members

Question 25 : Contents of sys.xml_schema_collections are :
1. Number of disk pages occupied
2. Indexing Capabilities
3. Predefined namespaces
4. None of the Mentioned
View Answer   Discuss with Members

Question 26 : The space use of XML indexes can be found in the table-valued function named?
1. sys.dm_db_index_physical_stats
2. sys.dm_db_index_phy_stats
3. sys.dm_db_index_plan_stats
4. sys.dm_db_index_table_stats
View Answer   Discuss with Members

Question 27 : What is index type for XML index entries ?
1. 3
2. 4
3. 5
4. 6
View Answer   Discuss with Members

Question 28 : Which of the following following is used for retrieving XML Schema Collections?
1. XML_SCHEMA_SPACE
2. XML_SCHEMA_NAMESPACE
3. XML_SCHEMA_NAMES
4. None of the Mentioned
View Answer   Discuss with Members

Question 29 : What are Catalog Views for XML ?
1. Schema collections
2. View Collections
3. Unstructured data
4. None of the Mentioned
View Answer   Discuss with Members

Question 30 : Which of the following feature of SQL Server was used before XML technology for semi structured data?
1. Stored Procedure
2. Dynamic management views
3. In memory database
4. None of the mentioned
View Answer   Discuss with Members