BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
varchar
|
|
|
nvarchar
|
|
|
char
|
|
|
to publish
|
Detailed explanation-1: -Char. Char is used to storing single character values, including numerical values. If you create an array of the character data type, it becomes a string that can store values such as name, subject, and more.
Detailed explanation-2: -The VARCHAR data type stores character strings of varying length that contain single-byte and (if the locale supports them) multibyte characters, where m is the maximum size (in bytes) of the column and r is the minimum number of bytes reserved for that column.
Detailed explanation-3: -In real life programming it’s almost always better to store first names, last names and similar data in nvarchar (unicode) data type rather than varchar.
Detailed explanation-4: -VARCHAR(255) stores 255 characters, which may be more than 255 bytes.