You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should you do?

• A. Use the CAST function.
• B. Use the VARBINARY data type.
• C. Use the DATETIME data type.
• D. Use the DATETIMEOFFSET data type.
• E. Use an appropriate collation.
• F. Use the TODATETIMEOFFSET function.
• G. Use the DATE data type.
• H. Use a user-defined table type.
• I. Use the FORMAT function.
• J. Use the DATETIME2 data type.

You maintain a SQL Server database that is used by a retailer to track sales and salespeople. The database includes two tables and two triggers that is defined by the following Transact-SQL statements:

During days with a large sales volume, some new sales transaction fail and report the following error: Arithmetic overflow error converting expression to data type int.
You need to ensure that the two triggers are applied once per sale, and that they do not interfere with each other.
How should you complete the relevant Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct location or locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

You administer a Microsoft SQL Server database that contains a table named Products.
In a bit column named Discontinued, a value of 1 indicates a product is inactive, and a value of 0 indicates the product is active.
You need to create a view that returns a column with a full product status description.
Which expression should you use to define the column?

• A. IF Discontinued = 0
  'Active'
  ELSE
  'Inactive'
• B. IF(Discontinued = 0, 'Active', 'Inactive')
• C. DECODE (Discontinued, 0, 'Active', 1, 'Inactive', 'Unknown')
• D. CASE Discontinued
  WHEN 0 THEN 'Active'
  WHEN 1 THEN 'Inactive'
  END

You use Microsoft SQL Server client tool to develop a Microsoft Azure SQL Database instance to support an e-commerce application. The database consists of a Product table, a Store table, and a StoreProduct table as shown in the exhibit. (Click the Exhibit button.) You need to write a trigger that meets the following requirements:
* Stores are not physically deleted, but are marked as deleted.
* When a store is deleted, the products that are sold in that store are marked as discontinued.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Exhibit

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.

• A. CREATE TABLE OrderDetails
  (
  ListPrice money NOT NULL,
  Quantity int NULL,
  LineItemTotal AS (ListPrice (Quantity) PERSISTED
  )
• B. CREATE TABLE OrderDetails
  (
  ListPrice money NOT NULL,
  Quantity int NOT NULL,
  LineItemTotal AS (ListPrice * Quantity) PERSISTED
  )