PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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?

4 Comments on “Which of the following SQL statements would properly remove all tuples for New York customers?

  1. Paul says:

    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




    0



    0
  2. Karen says:

    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)




    0



    0

Leave a Reply