The primary work key is a field or fields whose value uniquely ...

[saraeharris]

The primary work key is a field or fields whose value uniquely identifies a record.
 
  Indicate whether the statement is true or false

Question 2

Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.
 
  What will be an ideal response?

[lin77x]

Answer to Question 1

FALSE

Answer to Question 2

The Transact-SQL IDENTITY_INSERT property allows users to control whether or not the IDENTITY constraint is in effect. To insert non-sequential data, we (1 ) use the command SET IDENTITY_INSERT tableName OFF to disable the IDENTITY constraint, (2 ) insert the non-sequential data, and (3 ) use the command SET IDENTITY_INSERT TableName ON to enable the IDENTITY constraint again.