Home » MCQs » SQL MCQs » SQL Data Types MCQs

What is the difference between nvarchar and ntext?

16. What is the difference between nvarchar and ntext?

1. nvarchar is fixed and ntext is variable.
2. nvarchar is variable and ntext is fixed.
3. nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.
4. nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.

Answer: C) nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data

Explanation:

nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.