PrepAway - Latest Free Exam Questions & Answers

You need to create a table named OrderDetails on a new …

You need to create a table named OrderDetails on a new server. OrderDetails must meet the following requirements:
Contain a new column named LineltemTotal that stores the product of ListPrice and Quantity for each row.
The calculation for a line item total must not be run every time the table is queried.
The code must NOT use any object delimiters.
The solution must ensure that LineItemTotal is stored as the last column in the table.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
CREATE TABLE OrderDetails ( ListPrice money NOT NULL, Quantity int NOT NULL, LineItemTotal AS (ListPrice * Quantity) PERSISTED )

2 Comments on “You need to create a table named OrderDetails on a new …


Leave a Reply