Multiple choice technology databases

SQL 2005 XML data type instance storage has a limit. Choose the correct limit:

  1. 1 GB

  2. 1024 KB

  3. 2 GB

  4. 500 MB
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The XML data type in SQL Server 2005 can store up to 2 GB per instance, matching the maximum size for LOB types (varchar(max), nvarchar(max), varbinary(max)). This 2 GB limit applies to the XML document stored in the column. XML data is stored in an internal binary representation that preserves Unicode fidelity.

Keep practicing — related questions