Which three Transact-SQL statements should you use?

DRAG DROP
You use Microsoft SQL Server 2012 to develop a database application.
You create a table by using the following definition:
CREATE TABLE Prices (
PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
)
You need to create a computed column based on a user-defined function named udf_price_index.
You also need to ensure that the column supports an index.
Which three Transact-SQL statements should you use? (To answer, move the appropriate SQL
statements from the list of statements to the answer area and arrange them in the correct order.)

DRAG DROP
You use Microsoft SQL Server 2012 to develop a database application.
You create a table by using the following definition:
CREATE TABLE Prices (
PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
)
You need to create a computed column based on a user-defined function named udf_price_index.
You also need to ensure that the column supports an index.
Which three Transact-SQL statements should you use? (To answer, move the appropriate SQL
statements from the list of statements to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Show Hint

Leave a Reply 5

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

Mr Meat

Mr Meat

LOL.

That answer has nothing to do with the question. Actual answer should be:

SElECT DivisioniD AS Division, CustomerID AS Customer
FROM Div1Cust
UNION ALL
SELECT DivisionID, CustomerID
FROM Div2Cust

Reply

Mr Meat

Mr Meat

This belongs to question 98.

Reply

MKL

MKL

You’re right

Reply

Manuel

Manuel

Absolutely right

Reply

Peter

Peter

1) create function with parameters of type numeric(16, 9)
2) last one with declare @priceindex numeric(16,9)
3) add column with key word ‘persisted’ – it must support index

Reply