You have to design a table and application layout, in which automatic number generation is used.
The application also wants to assign database generated numbers in an SQL UPDATE statement.
Which statement is true?

A.
Neither Identity nor Sequence can deliver this functionality.

B.
Identity can deliver this functionality, but Sequence cannot.

C.
Identity cannot deliver this functionality, but Sequence can.

D.
Identity and Sequence can both deliver this functionality.

Explanation: