nerdexam
Microsoft

70-516 · Question #178

70-516 Question #178: Real Exam Question with Answer & Explanation

The correct answer is C. Order_Delete D. Order_Update. @productId parameter resides in the order table...

Question

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.)

Exhibit

70-516 question #178 exhibit

Options

  • AProduct_Delete
  • BProduct_Update
  • COrder_Delete
  • DOrder_Update

Explanation

@productId parameter resides in the order table...

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice