SQL SERVER – Quiz and Video – Introduction to Discovering XML Data Type Methods

This blog post is inspired from SQL Interoperability Joes 2 Pros: A Guide to Integrating SQL Server with XML, C#, and PowerShell – SQL Exam Prep Series 70-433 – Volume 5.

[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza]

This is follow up blog post of my earlier blog post on the same subject – SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer. In the article we discussed various basics terminology of the XML. The article further covers following important concepts of XML.

  • What are XML Data Type Methods
  • The query() Method
  • The value() Method
  • The exist() Method
  • The modify() Method

Above five are the most important concepts related to XML and SQL Server. There are many more things one has to learn but without beginners fundamentals one can’t learn the advanced  concepts. Let us have small quiz and check how many of you get the fundamentals right.

Quiz

1.) Which method returns an XML fragment from the source XML?

  1. query( )
  2. value( )
  3. exist( )
  4. modify( )
  5. All of them
  6. Only query( ) and value( )

2.) Which XML data type method returns a “1” if found and “0” if the specified XPath is not found in the source XML?

Solarwinds
  1. query( )
  2. value( )
  3. exist( )
  4. modify( )
  5. All of them
  6. Only query( ) and value( )

3.) Which XML data type method allows you to pick the data type of the value that is returned from the source XML?

  1. query( )
  2. value( )
  3. exist( )
  4. modify( )
  5. All of them
  6. Only query( ) and value( )

4.) Which method will not work with a SQL SELECT statement?

  1. query( )
  2. value( )
  3. exist( )
  4. modify( )
  5. All of them
  6. Only query( ) and value( )

Now make sure that you write down all the answers on the piece of paper.

Watch following video and read earlier article over here. If you want to change the answer you still have chance.

Solution

1) 1

2) 3

3) 2

4) 4

Now compare let us check the answers and compare your answers to following answers. I am very confident you will get them correct.

SQL SERVER - Quiz and Video - Introduction to Discovering XML Data Type Methods combos

Available at

USA: Amazon

India: Flipkart | IndiaPlaza

Volume: 1, 2, 3, 4, 5

Please leave your feedback in the comment area for the quiz and video. Did you know all the answers of the quiz?

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
Previous Post
SQL SERVER – Quiz and Video – Introduction to SQL Error Actions
Next Post
SQL SERVER – Developer Training Kit for SQL Server 2012

Related Posts

Leave a Reply

Menu