You need to create a database object that meets the following requirements:✑ accepts a product identified as input✑ calculates the total quantity of a specific product, including quantity on hand and quantity on order✑ caches and reuses execution plan✑ returns a value✑ can be called from within a SELECT statement✑ can be used in a JOIN clauseWhat should you create?
HOTSPOT -You have the following stored procedure:You run the following Transact-SQL statements:What is the result of each Transact-SQL statement? To answer, select the appropriate options in the answer area.Hot Area:
HOTSPOT -You need to develop a Transact-SQL statement that meets the following requirements:✑ The statement must return a custom error when there are problems updating a table.✑ The error number must be value50555.✑ Theerror severity level must be14.✑ A Microsoft SQL Server alert must be triggered when the error condition occurs.Which Transact-SQL segment should you use for each requirement? To answer, select the appropriate Transact-SQL segments in the answer area.Hot Area:
DRAG DROP -You need to create a stored procedure to update a table named Sales.Customers. The structure of the table is shown in the exhibit. (Click the exhibit button.)The stored procedure must meet the following requirements:✑ Accept two input parameters.✑ Update the company name if the customer exists.✑ Return a custom error message if the customer does not exist.Which five 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.NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.Select and Place:
You need to create an indexed view that requires logic statements to manipulate the data that the view displays.Which two database objects should you use? Each correct answer presents a complete solution.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section. You will NOT be able to return to it. As a result, these questions will not appear in the review screen.You create a table named Products by running the following Transact-SQL statement:You have the following stored procedure:You need to modify the stored procedure to meet the following new requirements:✑ Insert product records as a single unit of work.✑ Return error number 51000 when a product fails to insert into the database.✑ If a product record insert operation fails, the product information must not be permanently written to the database.Solution: You run the following Transact-SQL statement:Does the solution meet the goal?
