PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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.

2 Comments on “Which option should you chose to implement?


Leave a Reply