Which query should you use?

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?

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?

A.
UPDATE Production.Product
SET ListPrice = ListPrice + 20.00
WHERE NOT EXISTS (
SELECT VendorId FROM Purchasing.Vendor
WHERE VendorName = ‘Fabrikam’);

B.
UPDATE Production.Product SET ListPrice = ListPrice + 20.00
WHERE VendorId NOT IN (
SELECT VendorId FROM Purchasing.Vendor
WHERE VendorName = ‘Fabrikam’);

C.
UPDATE Production.Product SET ListPrice = ListPrice + 20.00
WHERE EXISTS (
SELECT VendorId FROM Purchasing.Vendor
WHERE VendorName = ‘Fabrikam’);

D.
UPDATE Production.Product SET ListPrice = ListPrice + 20.00 WHERE VendorId IN
(SELECT VendorId FROM Purchasing.Vendor
WHERE VendorName = ‘Fabrikam’);



Leave a Reply 0

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