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 LineltemTotal 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.

You administer a Microsoft SQL Server 2012 database. The database contains a table named
Employee. Part of the Employee table is shown in the exhibit.

Unless stated above, no columns in the Employee table reference other tables. Confidential
information about the employees is stored in a separate table named EmployeeData. One record
exists within EmployeeData for each record in the Employee table. You need to assign the
appropriate constraints and table properties to ensure data integrity and visibility. On which column
in the Employee table should you a create a self-reference foreign key constraint?

You want to add a new GUID column named BookGUID to a table named dbo.Book that already
contains data. BookGUID will have a constraint to ensure that it always has a value when new rows
are inserted into dbo.Book. You need to ensure that the new column is assigned a GUID for existing
rows. Which four 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.)

You administer a Microsoft SQL Server 2012 database. You use an OrderDetail table that has the
following definition.

You need to create a non-clustered index on the SalesOrderID column in the OrderDetail table to
include only rows that contain a value in the SpecialOfferID column. Which four Transact-SQL
statements should you use? (To answer, move the appropriate statements from the list of
statements to the answer area and arrange them in the correct order.)

You use a Microsoft SQL Server 2012 database. You need to create an indexed view within the
database for a report that displays Customer Name and the total revenue for that customer. Which
four T-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.)

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.)

You create a view based on the following statement.

You grant the Select permission to User1 for this view. You need to change the view so that it
displays only the records that were processed in the month prior to the current month. You need to
ensure that after the changes, the view functions correctly for User1. Which four 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.)

You use Microsoft SQL Server 2012 to develop a database that has two tables named Div1Cust
and Div2Cust. Each table has columns named DivisionID and CustomerId . None of the rows in
Div1Cust exist in Div2Cust. You need to write a query that meets the following requirements:
– The rows in Div1Cust must be combined with the rows in Div2Cust.
– The result set must have columns named Division and Customer.
– Duplicates must be retained.
Which three Transact-SQL statements should you use? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct order.)

You create the following stored procedure. (Line numbers are included for reference only.)

You need to ensure that the stored procedure performs the following tasks:
– If a record exists, update the record.
– If no record exists, insert a new record.
Which four Transact-SQL statements should you insert at line 07? (To answer, move the
appropriate statements from the list of statements to the answer area and arrange them in the
correct order.)

You use Microsoft SQL Server 2012 to develop a database application. You create two tables by
using the following table definitions.

Which five 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.)