nerdexam
Microsoft

70-433 · Question #114

You have tables named Sales.SalesOrderDetails and Sales.SalesOrderHeader. You have been tasked to update the discount amounts for the sales of a particular salesperson. You need to set…

The correct answer is A. UPDATE d SET UnitPriceDiscount = .1. See the full explanation below for the reasoning.

Question

You have tables named Sales.SalesOrderDetails and Sales.SalesOrderHeader. You have been tasked to update the discount amounts for the sales of a particular salesperson. You need to set UnitPriceDiscount to 0.1 for all entries in Sales.SalesOrderDetail that only correspond to SalesPersonID 290. Which Transact-SQL statement should you use?

Options

  • AUPDATE d SET UnitPriceDiscount = .1
  • BUPDATE Sales.SalesOrderDetail SET UnitPriceDiscount = .1
  • CUPDATE Sales.SalesOrderDetail SET UnitPriceDiscount = .1
  • DUPDATE Sales.SalesOrderDetail SET UnitPriceDiscount = .1

How the community answered

(31 responses)
  • A
    71% (22)
  • B
    3% (1)
  • C
    16% (5)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-433 Practice