Solved

Consider the Relation Shown in the Exhibit

Question 12

Multiple Choice

Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers? Consider the relation shown in the exhibit. Which of the following SQL statements would properly remove all tuples for New York customers?   A)  DELETE * FROM Customers WHERE Sales_Office = New York; B)  DELETE FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York? C)  DELETE * FROM Customers WHERE Sales_Office = ew D)  DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?


A) DELETE * FROM Customers WHERE Sales_Office = New York;
B) DELETE FROM Customers WHERE Sales_Office = ew York?WHERE Sales_Office = ?ew York?
C) DELETE * FROM Customers WHERE Sales_Office = ew
D) DELETE FROM Customers WHERE Sales_Office NOT LIKE ew York? WHERESales_Office NOT LIKE ?ew York?

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions