Which two procedures should you add to the @productId parameter?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 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. Which two procedures should you add to the @productId parameter? (Each correct answer presents part of the solution. Choose two.)

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 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. Which two procedures should you add to the @productId parameter? (Each correct answer presents part of the solution. Choose two.)

A.
Product_Delete

B.
Product_Update

C.
Order_Delete

D.
Order_Update



Leave a Reply 0

Your email address will not be published. Required fields are marked *