Which SQL data type is commonly used to store very large amounts of Unicode character data in SQL Server?

Options

  • A. VARCHAR(MAX)
  • B. NVARCHAR(MAX)
  • C. INT
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. NVARCHAR(MAX)

Detailed Explanation

  • NVARCHAR(MAX): Stores large variable-length Unicode character data in SQL Server.
  • It supports multilingual text.
  • VARCHAR(MAX) stores large variable-length non-Unicode character data under its applicable collation and encoding.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 2

Feature Posts