CIW Exam 1D0-541 Topic 4 Question 32 Discussion

Actual exam question for CIW's 1D0-541 exam

Question #: 32
Topic #: 4

Consider the relation shown in the exhibit. Which of the following SQL statements would

properly remove all tuples for New York customers?

ADELETE *
FROM Customers
WHERE Sales_Office = New York;

BDELETE
FROM Customers
WHERE Sales_Office = New York;

CDELETE *
FROM Customer
WHERE Sales_Office <> New York;

DDELETE
FROM Customers
WHERE Sales_Office NOT LIKE New York;

Show Suggested Answer

Suggested Answer: B

by Kristofer at May 08, 2022, 02:53 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!