gs gs116 Laying the Foundation - SQL Server Management Studio - Quiz No.2
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Laying the Foundation. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: What are Catalog Views for XML?
Schema collections
View Collections
Unstructured data
None of the Mentioned
Question 2: Which of the following following is used for retrieving XML Schema Collections?
XML_SCHEMA_SPACE
XML_SCHEMA_NAMESPACE
XML_SCHEMA_NAMES
None of the Mentioned
Question 4: The space use of XML indexes can be found in the table-valued function named?
sys.dm_db_index_physical_stats
sys.dm_db_index_phy_stats
sys.dm_db_index_plan_stats
sys.dm_db_index_table_stats
Question 5: Contents of sys.xml_schema_collections are _____________
Number of disk pages occupied
Indexing Capabilities
Predefined namespaces
None of the Mentioned
Question 6: Which of the following statement would import additional schema or schema components into an existing collection object?
IMPORT XML SCHEMA COLLECTION
ALTER XML SCHEMA COLLECTION
UPDATE XML SCHEMA COLLECTION
ADD XML SCHEMA COLLECTION
Question 7: Which operation cannot be performed on XML schema collection?
DROP
DELETE
CREATE
UPDATE
Question 8: Can we use untyped XML data type in the following situations?
You have schema for your XML data and you want the server to validate your XML data according to the XML schema
You want to take advantage of storage and query optimizations based on type information
You want to take better advantage of type information during compilation of your queries
You do not have a schema for your XML data
Question 9: Point out the wrong statement.
Typed XML type and Untyped XML both have XML schema to validate the Data
Typed XML type has advantage of storage and query optimizations where as Untyped XML type does not have this advantage
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
None of the mentioned
Question 10: SQL Server 2008 has made several extensions to the XML Schema support which includes?
Support for lax validation
Added support for list and union types
Improved handling of xs:time
All of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
