Limitations of the $XML$ Data Type are:
- It cannot be compared or sorted. This means an $XML$ data type cannot be used in a $\text{GROUP BY}$ statement
- It cannot be used as a key column in an index
- The value() method of the $XML$ data type returns a scalar value, so it can be specified anywhere where scalar values are allowed
- All of the options