Which option should you chose to implement?

You have a table named Sales that has the following three columns: Duty, Freight, and Customs.

You need to add new column to table which would show Sales+Freight+Customs.

Which option should you chose to implement?

You have a table named Sales that has the following three columns: Duty, Freight, and Customs.

You need to add new column to table which would show Sales+Freight+Customs.

Which option should you chose to implement?

A.
Persisted Computed Column

B.
Computed Column

C.
Numeric data type

D.
Money data type

Explanation:
Unless otherwise specified, computed columns are virtual columns that are not physically stored in the table. Their values are recalculated every time they are referenced in a query. The Database Engine uses the PERSISTED keyword in the CREATE TABLE and ALTER TABLE statements to physically store computed columns in the table. Their values are updated when any columns that are part of their calculation change.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Iwona

Iwona

I think C is not a correct answer. Even in comment there is information about persisted computed column. In my opinion the correct answer is A

ichko

ichko

Iwona I bet you’re BG 😉