Microsoft Exam Questions

Which three Transact-SQL statements should you use?

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: