Q. What is the difference between nvarchar and ntext?

  • (A) nvarchar is fixed and ntext is variable.
  • (B) nvarchar is variable and ntext is fixed.
  • (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.
  • (D) nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 1GB of the text data.
💬 Discuss
✅ Correct 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.

Published by Tina Singh ⭐ 14.41K Points at 13-Feb-2023 08:12 am in MySQL

Explanation by: Tina Singh
nvarchar can be of the maximum size upto 4000 characters and ntext can be of the maximum size upto 2GB of the text data.

💬 Discussion

📊 Question Analytics

👁️
218
Total Visits
📽️
4 y ago
Published
🎖️
Tina Singh
Publisher
📈
96%
Success Rate