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’);