PrepAway - Latest Free Exam Questions & Answers

What are the characteristics of the data?

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:

PrepAway - Latest Free Exam Questions & Answers

Answer:

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

2 Comments on “What are the characteristics of the data?


Leave a Reply