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 WHERESales_Office = ew
York?WHERE Sales_Office = ?ew York?
C.
DELETE * FROM Customers WHERESales_Office = ew
York?WHERE Sales_Office = ?ew York?
D.
DELETE FROM Customers WHERESales_Office NOT LIKE ew York? WHERE Sales_Office
NOT LIKE ?ew York?
Why is A not the correct answer?
The DELETE formula is:
DELETE FROM (table)
WHERE (condition)
The question mark is used as a place holder to create prepared statements, not a place holder for letters (uppercase or lowercase).
I believe it should be A as well
The DELETE command does not use the *.
DELETE FROM (relation)…
B is correct but displayed improperly.
Wrote my CIW Database Design Specialist 1D0-541 exam few days ago and passed with 92%! About 5 new questions, but not difficult at all. Total 50 questions, many questions on Normalization and Database Design/Structured Query Language (SQL), and DBMS/DDL/DML/DCL are still the most important objectives of the exam. BTW, the passing score now is 75%, and I learned all questions from passleader 1D0-541 dumps (http://www.passleader.com/1d0-541.html)