BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Zero
|
|
|
In white
|
|
|
A stranger
|
|
|
Invalid
|
Detailed explanation-1: -NULL values are used to indicate that you could have a value, but you don’t know what that value should be yet. They are placeholders until you finally collect the data needed to fill the table field with a real value. You should never confuse NULL values for zeros or blank strings.
Detailed explanation-2: -NULL indicates that the value is unknown. A null value is different from an empty or zero value. No two null values are equal. Comparisons between two null values, or between a null value and any other value, return unknown because the value of each NULL is unknown.
Detailed explanation-3: -You can use ISNULL or COALESCE functions to replace Null with value we like. Let’s create dbo. Customer table and insert sample records by using below statements. Let’s use ISNULL or COALESCE functions to replace Null with “Unknown Name".
Detailed explanation-4: -Note: A NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation!