Multiple Choice
Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________.
Customer table
A) SELECT * FROM Customer WHERE City NOT 'Pleasantville'
B) SELECT * FROM Customer WHERE NOT (City = 'Pleasantville')
C) SELECT * FROM Customer WHERE City <> 'Pleasantville'
D) SELECT * FROM Customer WHERE City != 'Pleasantville'
Correct Answer:

Verified
Correct Answer:
Verified
Q20: A _ object can create statement objects
Q21: In SQL, _ is used to test
Q22: What is the purpose of a primary
Q23: One of the steps for testing the
Q24: A _ is a set of rows
Q26: When you are done with a Statement
Q27: Used with the LIKE operator, the _
Q28: If your program needs to look at
Q29: When you close a connection:<br>A)it closes the
Q30: What is wrong with the following statement?<br>ResultSet