Multiple choice technology databases

Which of the following is true about XML columns?

  1. XML columns are used to store XML documents as a hierarchical set of entities

  2. Only XQuery can be used to retrieve an XML document from an XML column

  3. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

  4. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

XML columns store XML documents natively in their hierarchical structure, preserving the document's entity relationships and organization. DB2 supports multiple retrieval methods including XQuery, SQL/XML functions, and XPath. You can extract portions of XML documents without retrieving the entire document, and XML columns don't require structural alterations for referential constraints as they maintain document integrity internally.

Keep practicing — related questions