Can We Use Untyped Xml Data Type In The Following Situations #28
Can we use untyped XML data type in the following situations?
This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Laying the Foundation - SQL Server Management Studio - Quiz No.2.
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
Similar question(s) are as followings:
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