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 arrangethem
in the correct order.)

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 arrangethem
in the correct order.)

Answer:

Explanation:



Leave a Reply 0

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