HOTSPOT
You run the following Transact-SQL statement:
You need to ensure that you can insert data into the table.
What are the characteristics of the data? To answer, select the appropriate options in the answer area.
Hot Area:
Explanation:
Box 1: custid
IDENTITY indicates that the new column is an identity column. When a new row is added to the table, the
Database Engine provides a unique, incremental value for the column. Identity columns are typically used with
PRIMARY KEY constraints to serve as the unique row identifier for the table.
Box2: postalcode
postalcode is declared as NOT NULL, which means that a value must be inserted.
Box 3: region
Fax is also a correct answer. Both these two columns are declared as NULL, which means that data entry is
optional.
https://msdn.microsoft.com/en-us/library/ms174979.aspx
Why are we still choosing one between region and Fax while they are both correct.
One of those bad MS questions