70-461 – Querying Microsoft SQL Server 2012

DRAG DROP

You need to create a stored procedure that enters values into multiple tables. The solution must ensure that if a single insert fails, none of the values are inserted into the tables.

How should you complete the stored procedure? To answer, drag the appropriate values to the correct locations. Each value 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.

Select and Place:

DRAG DROP

You use a Microsoft Azure SQL Database instance named ContosoDb. ContosoDb contains a table named Products that has existing records.

The Products table has columns named Code and QuantityOnHand.

You need to create a new column in the Products table named Category that allows null values and sets the value of the Category column to General for all existing records.

Which three 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.

Select and Place:

HOTSPOT

You are developing an SQL Server database. The database contains two tables and a function that are defined by the following Transact-SQL statements.

You need to create a query to determine the total number of products that are sold each day for the five top-selling products on that particular day.

How should you complete the Transact-SQL script? To answer, select the appropriate Transact-SQL statements in the answer area.

Hot Area: