PrepAway - Latest Free Exam Questions & Answers

which two procedures should you add the @productId parameter?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create stored procedures by using the following signatures:

CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price float)
CREATE procedure [dbo].[Product_Delete](@id int)
CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp timestamp)
CREATE procedure [dbo].[Order_Delete](@id int)

You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit:

You need to map the Product and Order entities to the stored procedures. To which two procedures should you add the @productId parameter?
(Each correct answer presents part of the solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Product_Delete

B.
Product_Update

C.
Order_Delete

D.
Order_Update

Explanation:
@productId parameter resides in the order table…


Leave a Reply