nerdexam
Microsoft

70-433 · Question #74

Your company stores vendor and price information in a database. All items in the database have a list price. You need to increase the list price for all products of only the vendor named Fabrikam by…

The correct answer is D. UPDATE Production.Product. See the full explanation below for the reasoning.

Question

Your company stores vendor and price information in a database. All items in the database have a list price. You need to increase the list price for all products of only the vendor named Fabrikam by 20.00. Which query should you use?

Options

  • AUPDATE Production.Product
  • BUPDATE Production.Product
  • CUPDATE Production.Product
  • DUPDATE Production.Product

How the community answered

(34 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    15% (5)
  • D
    76% (26)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice