Multiple Choice Questions - XML Data Type & Columns
1. XML is a good choice if
A) You want a platform-independent model in order to ensure portability of the data by using structural and semantic markup.
B) Your data is not sparse.
C) Your data represents containment hierarchy, instead of references among entities, and may be recursive.
D) Order is not inherent in your data.
E) You want to query into the data or update parts of it, based on its structure.
2. SQL Server uses different locking mechanism for both XML and non-XML data.
A) True
B) False
3. The storage options for XML in SQL Server include the following:
A) Native storage as xml data type
B) Mapping between XML and relational storage
C) Large object storage, [n]varchar(max) and varbinary(max)
D) Both A & B
E) All of above
4. Which of the below XML data type method or methods would you use to retrieve scalar values from an XML instance?
A) value()
B) nodes()
C) query()
D) modify()
5. The XML data type is a large object type. There can be upto . . . . . of data in every single column value.
A) 256 MB
B) 512 MB
C) 1GB
D) 2GB
6. The granularity of the XML data stored in an XML column is very important for locking and, to a lesser degree, it is also important for . . . . . . .
A) inserts
B) deletions
C) updates
D) all of above
7. SQL Server also supports . . . . . . . constraints on columns of XML type.
A) Null
B) Not Null
C) Both A & B
D) None of above
8. The default encoding for the XML datatype is . . . . . . .
A) UTF-8
B) UTF-16
C) UTF-32
D) UTF-64
9. Limitations of the XML Data Type are:
A) It cannot be compared or sorted. This means an xml data type cannot be used in a GROUP BY statement.
B) It cannot be used as a key column in an index.
C) The value() method of the XML data type returns a scalar value, so it can be specified anywhere where scalar values are allowed.
D) All of above.
E) Both A & B
10. You can use the XML data type as a column type when you create a table as .........
A) a variable type
B) a parameter type
C) a function-return type
D) All of above
E) None of above
Answers