gs gs116 SQL Server Beyond Relational - Working With XML Data - Quiz No.1
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 SQL Server Beyond Relational. 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: Which of the reasons will force you to use XML data model in SQL Server?
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
Question 2: Which of the following is not a XML storage option?
Native storage as XML data type
Mapping between XML and relational storage
Small object storage
None of the Mentioned
Question 3: The choice of XML technology, native XML versus XML view, generally depends upon the following factors?
Storage options
Query capabilities
Indexing
All of the Mentioned
Question 4: In which of the following scenario, using XML native storage would be inappropriate?
Fixed schema
You want to query and modify your XML data
You want to index the XML data for faster query processing
Your application needs system catalog views to administer your XML data and XML schema
Question 5: XML View Technology is useful in the following situations?
Your application needs system catalog views to administer your XML data and XML schema
Indexing Capabilities
You want to bulk load XML data and decompose them into the underlying tables by using the XML view
None of the Mentioned
Question 6: What is the hybrid model in SQL Server?
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
Question 7: 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
Question 8: Which of the following part of the XML data stored in an XML column is very important for locking?
Granularity
Degree of Structure
Hierarchy
None of the mentioned
Question 9: XML datatype was introduced in which of the following versions of SQL Server?
SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server 2012
Question 10: Which of the following feature of SQL Server was used before XML technology for semi structured data?
Stored Procedure
Dynamic management views
In memory database
None 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
