PrepAway - Latest Free Exam Questions & Answers

where is the data stored for a column defined with an XML data type?

By default, where is the data stored for a column defined with an XML data type?

PrepAway - Latest Free Exam Questions & Answers

A.
In line with the rest of the data for the table, for XML columns less than 32KB.

B.
In an XML index.

C.
In line with the rest of the data for the table.

D.
In an XML storage object that is separate from the table.

One Comment on “where is the data stored for a column defined with an XML data type?

  1. db2man says:

    D)

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.xml.doc/doc/c0050646.html

    XML storage object
    This is the default method of storing XML documents. Documents that require more than 32 KB of storage space, or larger than the page size, are always stored in the default storage object, regardless of your storage choice. Storage in the default storage object allows you to insert and retrieve XML documents up to 2 gigabytes in size.




    0



    0

Leave a Reply