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:
Suggested Answer:
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. References: https://msdn.microsoft.com/en-us/library/ms174979.aspx
Values cannot be entered into this column: custid (is generated automatically)
A must value must be inserted into this column: postalcode
Data entry into this column is optional : fax and region
1. Custid - Identity (can't insert unless IDENTITY_INSERT ON)
2. Postal Code - NOT NULL
3. Fax & Region NULL
ON PRIMARY is a red herring - just creating on primary file group
By default, identity column would be automatically populated according to column increment setting and it can't be inserted/updated. Unless if you manually set Identify_insert on in some situations, e.g. if you want to copy all current values from existing table to this table and you still want to use old identity values instead of generating new identity for each inserted rows.
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-identity-insert-transact-sql?view=sql-server-ver15
Yes and I think for "..must be inserted" is for custid also.
cause is marked as not null and we cannot insert any value without filling identity property
This section is not available anymore. Please use the main Exam Page.70-761 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Vanesa30
Highly Voted 5 years, 3 months agoAnette
5 years agoM4x
Highly Voted 5 years, 8 months agoVermonster
Most Recent 4 years, 4 months agoRobintang0924
5 years, 3 months agoBartek
5 years, 8 months agoAlmosawi
5 years, 7 months agomattia_88
5 years, 6 months agokimalto452
4 years, 4 months ago