Lookup

Created by info@itofthefuture.com

Welcome Anonimous.User to this quiz related to Test JSP and Servlets.

Read the question and choose the best answer. Time is limited to 40 seconds!

Important! Do not forget to rank the quality of the question (from bad to excellent).
An initiator of the quiz will get royalty score for QnAs created by her/him and can win the Top Creativity Prize.

Question:
The following code retrieves a List of Customer from a database: List customers = DataService.getData("queryString", Customer.class); This assumes a file queryString.sql at a certain location. This file contains the SQL statement to get the data. Identify the best way to retrieve all female customers from the database who are 42 years old. (Choose one.)

queryString.sql:
SELECT id, name, sex, address, age FROM customers
WHERE sex=1 AND age = 42
in the program:
List<Customer> females = new ArrayList<Customer>();
for (Customer c : customers) {
if (c.getAge() == 42 && c.getSex() == Sex.FEMALE) {
females.add(c);
}
}

queryString.sql:
UPDATE id, name, sex, address, age FROM customers
WHERE sex=1 OR age = 42
in the program:
List<Customer> females = new ArrayList<Customer>();
for (Customer c : customers) {
if (c.getAge() != 42 && c.getSex() != Sex.FEMALE) {
females.add(c);
}
}

queryString.sql:
SELECT id, name, sex, address FROM customers;
in the program:
List<Customer> females = new ArrayList<Customer>();
for (Customer c : customers) {
if (c.getAge() == 42 && c.getSex() == Sex.FEMALE) {
females.add(c);
}
}

queryString.sql:
SELECT id, name, sex, address, age FROM customers
WHERE sex=1 AND age = 42

Rank the Quality of the Question from "-10" (bad) or "0" (not clear) to 10 (correct) or even 20 (very good!)
-10 (bad/wrong) 0 (not clear) 10 (correct) 20 (very good!)

Your summary report will be available to you and your instructor. Thank you for your work!!!